----本用戶所擁有的系統許可權:
select * from user_sys_privs;
---本用戶讀取其他用戶對象的許可權:
select * from user_tab_privs;
-----添加許可權
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO 用戶名(accor)
-----創建臨時表空間
create temporary tablespace accor_ts
tempfile 'd:/accorDB' ----『數據文件存放路徑』
size 32M ----文件大小
autoextend on
next 32M maxsize 2048M
extent management local;
----創建表空間
create tablespace accor_test
datafile 'd:/accorDataBase' ----『數據文件存放路徑』
size 32M ----文件大小
autoextend on
next 32M maxsize 2048M
extent management local;
-----創建用戶
create user accor identified by accor(用戶密碼)
default tablespace accor_test -----默認表空間
temporary tablespace accor_ts -----臨時表空間
----刪除用戶
---- 用戶下存在對象,表示要連帶對象一起刪除
drop user accor cascade;
---- 最快的辦法是:
conn /as sysdba
delete from user$ where name='dzysc';
commit;
alter system flush shared_pool;
----給用戶授權
grant connect,resource,create session,dba to accor
--更換用戶登陸 disconnect
conn username/password@實例ID
select * from user_sys_privs;
導出命令:
exp uat_acc/uat_acc@ACCOR file=./uat_accor_0429.dmp owner=uat_acc;
導入命令:
imp uat_acc2/uat_acc2@ACCOR file=./test_acc_0413.dmp fromuser=uat_acc2 touser=uat_acc2;