Oracle学习笔记_05_ 一个创建表空间、创建用户、授权的完整过程

su - oracle
sqlplus /nolog
conn /as sysdba

create tablespace scaninvoice logging datafile '/u01/app/oracle/oradata/mas/scaninvoice.dbf' size 200M autoextend on next 100m  extent management local;
create temporary tablespace scaninvoice_tmp tempfile '/u01/app/oracle/oradata/mas/scaninvoice_tmp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create user  username  identified by password default tablespace scaninvoice 
temporary tablespace scaninvoice_tmp;        

grant dba to trainhec ;
grant dba,create session,resource,connect to trainhec ;
exit；  

# su - oracle
$ sqlplus /nolog
SQL> conn /as sysdba

create tablespace scaninvoice logging datafile '/u01/app/oracle/oradata/mas/scaninvoice.dbf' size 200M autoextend on next 100m  extent management local;

create temporary tablespace scaninvoice_tmp tempfile '/u01/app/oracle/oradata/mas/scaninvoice_tmp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create user  username  identified by password;    //使用默认表空间 USER

create user  username  identified by password default tablespace scaninvoice 
temporary tablespace scaninvoice_tmp;            //指定默认表空间和临时表空间  (推荐)

grant dba to trainhec ;
grant dba,create session,resource,connect to trainhec ;
exit；

alter user username  identified by password; 

select username,default_tablespace from dba_users;  

alter user scaninvoice default tablespace scaninvoice;