目前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';