oracle 常用操作
建用戶(hù):
CREATE USER xxx IDENTIFIED BY?xxx
???????? DEFAULT TABLESPACE?User
???????? TEMPORARY TABLESPACE temp
權(quán)限:
???????? DEFAULT TABLESPACE?User
???????? TEMPORARY TABLESPACE temp
權(quán)限:
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
?
刪掉用戶(hù)
drop user? xxx? cascade
posted on 2006-09-20 21:20 dreamstone 閱讀(177) 評(píng)論(0) 編輯 收藏 所屬分類(lèi): 片段