----本用户所拥有的系统权限:
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;