Oracle user operations

Oracle user related operations currently orcl databases use sys as sysdba to create users: 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 limit; create user eprk_dev identified by eprk_dev default tablespace limit temporary tablespace temp; grant dba to eprk_dev; alter user eprk_dev quota unlimited on limit; create user wujian identified by wujian default tablespace users temporary tablespace temp; grant create session to wujian; grant create table to wujian; -- change the user's quota on the tablespace, after 10gR2, you cannot assign alter user wujian quota unlimited on users in temp; -- assign dba role grant dba to wujian; -- assign all object permission grant all on wujian. "user" to wujian; -- query the system permissions owned by the user. select * from dba_sys_privs where lower (grantee) = 'wujian '; -- query the object permissions owned by a user. select * from dba_tab_privs where lower (grantee) = 'wujian ';