建用戶:
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