Oracle用户相关操作
Oracle用户相关操作
目前orcl数据库用sys as sysdba创建用户:
create user epa_dev identified by epa_dev default tablespace NNC_DATA01 temporary tablespace temp;
grant create session to epa_dev;
grant create table to epa_dev;
grant dba to epa_dev;
alter user epa_dev quota unlimited on NNC_DATA01;
create user eprk_dev identified by eprk_dev default tablespace NNC_DATA01 temporary tablespace temp;
grant dba to eprk_dev;
alter user eprk_dev quota unlimited on NNC_DATA01;
create user wujian identified by wujian default tablespace users temporary tablespace temp;
grant create session to wujian;
grant create table to wujian;
--改变用户在表空间上的配额,10gR2后不能在temp分配
alter user wujian quota unlimited on users;
--分配dba角色
grant dba to wujian;
--分配all对象权限
grant all on wujian."user" to wujian;
--查询用户所拥有的系统权限
select * from dba_sys_privs where lower(grantee)='wujian';
--查询用户所拥有的对象权限
select * from dba_tab_privs where lower(grantee)='wujian';