oracle 常用操作
建用戶:
CREATE USER xxx IDENTIFIED BY?xxx
???????? DEFAULT TABLESPACE?User
???????? TEMPORARY TABLESPACE temp
權限:
???????? DEFAULT TABLESPACE?User
???????? TEMPORARY TABLESPACE temp
權限:
grant connect,resources,imp_full _database,exp_full_database,
???????? create public synonym,drop public synonym to xxx;
???????? create public synonym,drop public synonym to xxx;
grant connect,resources,sysdba to xxx
?
imp/exp
?
刪掉用戶
drop user? xxx? cascade
posted on 2006-09-20 21:20 dreamstone 閱讀(177) 評論(0) 編輯 收藏 所屬分類: 片段