oracle 常用操作

 

建用户：

CREATE USER xxx IDENTIFIED BY xxx
         DEFAULT TABLESPACE User
         TEMPORARY TABLESPACE temp
权限：

grant connect,resources,imp_full_database,exp_full_database,
         create public synonym,drop public synonym to xxx;

grant connect,resources,sysdba to xxx

 

imp/exp

 

删掉用户

drop user  xxx  cascade