Oracle创建表空间并赋权

SQL>
create tablespace stu_data
datafile 'E:G3T05oraclet1stu_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
 
Tablespace created
 
SQL>
SQL>
create temporary tablespace stu_temp
tempfile 'E:G3T05oraclet1stu_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
 
 
SQL> 
create user tudou identified by "111"
default tablespace stu_data
temporary tablespace stu_temp; 
 
User created
 
SQL> grant connect,resource to tudou; 

您可能感兴趣的文章: