http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2Fdba_users Oracle PL/SQL Tutorial/System Tables Data Dictionary/dba users - История изменений 2026-05-25T16:54:45Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/dba_users&diff=3965&oldid=prev в 13:45, 26 мая 2010 2010-05-26T13:45:46Z <p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table> http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/dba_users&diff=3966&oldid=prev Admin: 1 версия 2010-05-26T10:08:13Z <p>1 версия</p> <p><b>Новая страница</b></p><div>== Check user name and password for users==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt; select<br /> 2 Username, /*Username*/<br /> 3 Password /*Encrypted password*/<br /> 4 from DBA_USERS<br /> 5 where Username in (&quot;MCGREGOR&quot;,&quot;THUMPER&quot;,&quot;OPS$FARMER&quot;);<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == Join dba_users and dba_tab_privs to find out user privileges==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; COLUMN object FORMAT a25<br /> SQL&gt; COLUMN grantee FORMAT a15<br /> SQL&gt; SELECT b.owner || &quot;.&quot; || b.table_name object,<br /> 2 b.privilege what_granted, b.grantable, a.username<br /> 3 FROM dba_users a, dba_tab_privs b<br /> 4 WHERE a.username = b.grantee<br /> 5 AND privilege = &quot;EXECUTE&quot;<br /> 6 and rownum &lt; 50<br /> 7 ORDER BY 1,2,3;<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> CTXSYS.CTX_DDL EXECUTE NO<br /> XDB<br /> CTXSYS.CTX_DDL EXECUTE YES<br /> FLOWS_020100<br /> CTXSYS.CTX_DOC EXECUTE YES<br /> FLOWS_020100<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> CTXSYS.CTX_OUTPUT EXECUTE NO<br /> XDB<br /> FLOWS_020100.WWV_FLOW EXECUTE NO<br /> FLOWS_FILES<br /> FLOWS_020100.WWV_FLOW_EPG EXECUTE NO<br /> _INCLUDE_MODULES<br /> ANONYMOUS<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> FLOWS_020100.WWV_FLOW_FIL EXECUTE NO<br /> E_API<br /> FLOWS_FILES<br /> FLOWS_020100.WWV_FLOW_FIL EXECUTE NO<br /> E_OBJECT_ID<br /> FLOWS_FILES<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> FLOWS_020100.WWV_FLOW_ID EXECUTE NO<br /> FLOWS_FILES<br /> FLOWS_020100.WWV_FLOW_SEC EXECUTE NO<br /> URITY<br /> FLOWS_FILES<br /> SYS.CHECK_UPGRADE EXECUTE NO<br /> SYSTEM<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> SYS.CHECK_UPGRADE EXECUTE NO<br /> XDB<br /> SYS.DBMS_ALERT EXECUTE NO<br /> SYSTEM<br /> SYS.DBMS_AQ EXECUTE YES<br /> SYSTEM<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> SYS.DBMS_AQADM EXECUTE YES<br /> SYSTEM<br /> SYS.DBMS_AQELM EXECUTE YES<br /> SYSTEM<br /> SYS.DBMS_AQ_BQVIEW EXECUTE NO<br /> sqle<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> SYS.DBMS_AQ_IMPORT_INTERN EXECUTE YES<br /> AL<br /> SYSTEM<br /> SYS.DBMS_CRYPTO EXECUTE NO<br /> FLOWS_020100<br /> SYS.DBMS_DEFER_IMPORT_INT EXECUTE NO<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> ERNAL<br /> SYSTEM<br /> SYS.DBMS_FLASHBACK EXECUTE NO<br /> FLOWS_020100<br /> SYS.DBMS_LOCK EXECUTE NO<br /> FLOWS_020100<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> SYS.DBMS_LOCK EXECUTE NO<br /> CTXSYS<br /> SYS.DBMS_LOCK EXECUTE NO<br /> MDSYS<br /> SYS.DBMS_PIPE EXECUTE NO<br /> CTXSYS<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> SYS.DBMS_REGISTRY EXECUTE NO<br /> CTXSYS<br /> SYS.DBMS_REGISTRY EXECUTE NO<br /> MDSYS<br /> SYS.DBMS_REGISTRY EXECUTE NO<br /> XDB<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> SYS.DBMS_REPCAT EXECUTE NO<br /> SYSTEM<br /> SYS.DBMS_RLS EXECUTE NO<br /> XDB<br /> SYS.DBMS_RLS EXECUTE YES<br /> FLOWS_020100<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> SYS.DBMS_RULE_EXIMP EXECUTE YES<br /> SYSTEM<br /> SYS.DBMS_SERVER_ALERT EXECUTE NO<br /> DBSNMP<br /> SYS.DBMS_STATS EXECUTE NO<br /> HR<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> SYS.DBMS_SYSTEM EXECUTE NO<br /> MDSYS<br /> SYS.DBMS_SYS_ERROR EXECUTE NO<br /> SYSTEM<br /> SYS.DBMS_SYS_SQL EXECUTE NO<br /> FLOWS_020100<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> SYS.DBMS_SYS_SQL EXECUTE NO<br /> XDB<br /> SYS.DBMS_TRANSFORM_EXIMP EXECUTE YES<br /> SYSTEM<br /> SYS.OUTLN_PKG EXECUTE NO<br /> OUTLN<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> SYS.SET_TABLESPACE EXECUTE NO<br /> XDB<br /> SYS.SET_TABLESPACE EXECUTE NO<br /> SYSTEM<br /> SYS.SYS_GROUP EXECUTE NO<br /> SYSTEM<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> SYS.UTL_FILE EXECUTE NO<br /> XDB<br /> SYS.UTL_FILE EXECUTE NO<br /> FLOWS_020100<br /> SYS.UTL_HTTP EXECUTE NO<br /> FLOWS_020100<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> USERNAME<br /> ------------------------------<br /> SYS.UTL_SMTP EXECUTE NO<br /> FLOWS_020100<br /> SYS.VALIDATE_CONTEXT EXECUTE NO<br /> CTXSYS<br /> SYS.WWV_FLOW_VAL EXECUTE NO<br /> FLOWS_020100<br /> <br /> 49 rows selected.<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == Join dba_users, dba_tab_privs==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt; SET FEEDBACK OFF<br /> SQL&gt; SET PAGESIZE 20<br /> SQL&gt; SET LINESIZE 77<br /> SQL&gt; SET HEADING ON<br /> SQL&gt;<br /> SQL&gt; COLUMN username FORMAT A12 HEADING &quot;User&quot;<br /> SQL&gt; COLUMN privilege FORMAT A20 HEADING &quot;Privilege&quot;<br /> SQL&gt; COLUMN owner FORMAT A12 HEADING &quot;Table Owner&quot;<br /> SQL&gt; COLUMN table_name FORMAT A30 HEADING &quot;Table Name&quot;<br /> SQL&gt; TTITLE LEFT &quot;User Table Privileges&quot; RIGHT &quot;Page &quot; FORMAT 999 SQL.PNO SKIP 2<br /> SQL&gt;<br /> SQL&gt; SELECT username, privilege, owner, table_name<br /> 2 FROM dba_users, dba_tab_privs<br /> 3 WHERE username = grantee<br /> 4 ORDER BY username, owner, table_name, privilege;<br /> User Table Privileges Page 1<br /> User Privilege Table Owner Table Name<br /> ------------ -------------------- ------------ ------------------------------<br /> ANONYMOUS EXECUTE FLOWS_020100 WWV_FLOW_EPG_INCLUDE_MODULES<br /> ANONYMOUS ALTER FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS DEBUG FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS DELETE FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS FLASHBACK FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS INDEX FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS INSERT FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS ON COMMIT REFRESH FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS QUERY REWRITE FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS REFERENCES FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS SELECT FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS UPDATE FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> CTXSYS SELECT SYS ARGUMENT$<br /> CTXSYS SELECT SYS CCOL$<br /> CTXSYS SELECT SYS CDEF$<br /> User Table Privileges Page 2<br /> User Privilege Table Owner Table Name<br /> ------------ -------------------- ------------ ------------------------------<br /> CTXSYS SELECT SYS COL$<br /> CTXSYS SELECT SYS COLTYPE$<br /> CTXSYS SELECT SYS CON$<br /> CTXSYS SELECT SYS DBA_COLL_TYPES<br /> CTXSYS SELECT SYS DBA_CONSTRAINTS<br /> CTXSYS SELECT SYS DBA_CONS_COLUMNS<br /> CTXSYS SELECT SYS DBA_DB_LINKS<br /> CTXSYS SELECT SYS DBA_INDEXTYPES<br /> CTXSYS SELECT SYS DBA_JOBS<br /> CTXSYS SELECT SYS DBA_JOBS_RUNNING<br /> CTXSYS SELECT SYS DBA_OBJECTS<br /> CTXSYS SELECT SYS DBA_ROLES<br /> CTXSYS SELECT SYS DBA_ROLE_PRIVS<br /> CTXSYS SELECT SYS DBA_SYNONYMS<br /> CTXSYS SELECT SYS DBA_SYS_PRIVS<br /> User Table Privileges Page 3<br /> User Privilege Table Owner Table Name<br /> ------------ -------------------- ------------ ------------------------------<br /> CTXSYS SELECT SYS DBA_TABLES<br /> CTXSYS SELECT SYS DBA_TAB_COLS<br /> CTXSYS SELECT SYS DBA_TAB_COLUMNS<br /> CTXSYS SELECT SYS DBA_TAB_PARTITIONS<br /> CTXSYS SELECT SYS DBA_TAB_PRIVS<br /> CTXSYS SELECT SYS DBA_TYPES<br /> CTXSYS SELECT SYS DBA_TYPE_ATTRS<br /> CTXSYS SELECT SYS DBA_USERS<br /> CTXSYS EXECUTE SYS DBMS_LOCK<br /> CTXSYS EXECUTE SYS DBMS_PIPE<br /> CTXSYS EXECUTE SYS DBMS_REGISTRY<br /> CTXSYS SELECT SYS GV_$PARAMETER<br /> CTXSYS SELECT SYS HIST_HEAD$<br /> CTXSYS SELECT SYS ICOL$<br /> CTXSYS SELECT SYS IND$<br /> User Table Privileges Page 4<br /> User Privilege Table Owner Table Name<br /> ------------ -------------------- ------------ ------------------------------<br /> CTXSYS SELECT SYS INDPART$<br /> CTXSYS SELECT SYS LOB$<br /> CTXSYS SELECT SYS LOBFRAG$<br /> CTXSYS SELECT SYS OBJ$<br /> CTXSYS SELECT SYS PARTOBJ$<br /> CTXSYS SELECT SYS SYN$<br /> CTXSYS SELECT SYS SYSAUTH$<br /> CTXSYS SELECT SYS TAB$<br /> CTXSYS SELECT SYS TABPART$<br /> CTXSYS SELECT SYS TS$<br /> CTXSYS SELECT SYS USER$<br /> CTXSYS EXECUTE SYS VALIDATE_CONTEXT<br /> CTXSYS SELECT SYS VIEW$<br /> CTXSYS SELECT SYS V_$PARAMETER<br /> CTXSYS SELECT SYS V_$RESOURCE<br /> User Table Privileges Page 5<br /> User Privilege Table Owner Table Name<br /> ------------ -------------------- ------------ ------------------------------<br /> CTXSYS SELECT SYS V_$SESSION<br /> CTXSYS SELECT SYS V_$THREAD<br /> DBSNMP EXECUTE SYS DBMS_SERVER_ALERT<br /> FLOWS_020100 EXECUTE CTXSYS CTX_DDL<br /> FLOWS_020100 EXECUTE CTXSYS CTX_DOC<br /> FLOWS_020100 ALTER FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 DEBUG FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 DELETE FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 FLASHBACK FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 INDEX FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 INSERT FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 ON COMMIT REFRESH FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 QUERY REWRITE FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 REFERENCES FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 SELECT FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> SQL&gt; SET FEEDBACK ON<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == Union user name from sys.dba_users table==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt; SELECT a.username,<br /> 2 b.granted_role || DECODE(admin_option,&quot;YES&quot;,<br /> 3 &quot; (With Admin Option)&quot;,NULL) what_granted<br /> 4 FROM sys.dba_users a, sys.dba_role_privs b<br /> 5 WHERE a.username = b.grantee and rownum &lt; 50<br /> 6 UNION<br /> 7 SELECT a.username,<br /> 8 b.privilege || DECODE(admin_option,&quot;YES&quot;,<br /> 9 &quot; (With Admin Option)&quot;, NULL) what_granted<br /> 10 FROM sys.dba_users a, sys.dba_sys_privs b<br /> 11 WHERE a.username = b.grantee and rownum &lt; 50<br /> 12 UNION<br /> 13 SELECT a.username,<br /> 14 b.table_name || &quot; - &quot; || b.privilege<br /> 15 || DECODE(grantable,&quot;YES&quot;,<br /> 16 &quot; (With Grant Option)&quot;,NULL) what_granted<br /> 17 FROM sys.dba_users a, sys.dba_tab_privs b<br /> 18 WHERE a.username = b.grantee and rownum &lt; 50<br /> 19 ORDER BY 1;<br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> CTXSYS<br /> ARGUMENT$ - SELECT (With Grant Option)<br /> CTXSYS<br /> CCOL$ - SELECT (With Grant Option)<br /> CTXSYS<br /> CDEF$ - SELECT (With Grant Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> CTXSYS<br /> COL$ - SELECT (With Grant Option)<br /> CTXSYS<br /> CON$ - SELECT (With Grant Option)<br /> CTXSYS<br /> CREATE SESSION<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> CTXSYS<br /> CTXAPP (With Admin Option)<br /> CTXSYS<br /> ICOL$ - SELECT (With Grant Option)<br /> CTXSYS<br /> IND$ - SELECT (With Grant Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> CTXSYS<br /> OBJ$ - SELECT (With Grant Option)<br /> CTXSYS<br /> RESOURCE<br /> CTXSYS<br /> SYN$ - SELECT (With Grant Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> CTXSYS<br /> SYSAUTH$ - SELECT (With Grant Option)<br /> CTXSYS<br /> TAB$ - SELECT (With Grant Option)<br /> CTXSYS<br /> TS$ - SELECT (With Grant Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> CTXSYS<br /> USER$ - SELECT (With Grant Option)<br /> CTXSYS<br /> VIEW$ - SELECT (With Grant Option)<br /> DBSNMP<br /> CREATE PROCEDURE<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> DBSNMP<br /> OEM_MONITOR<br /> FLOWS_020100<br /> ALTER USER<br /> FLOWS_020100<br /> CONNECT (With Admin Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> FLOWS_020100<br /> CREATE ANY CONTEXT (With Admin Option)<br /> FLOWS_020100<br /> CREATE ANY DIRECTORY<br /> FLOWS_020100<br /> CREATE DATABASE LINK (With Admin Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> FLOWS_020100<br /> CREATE DIMENSION (With Admin Option)<br /> FLOWS_020100<br /> CREATE LIBRARY (With Admin Option)<br /> FLOWS_020100<br /> CREATE PUBLIC SYNONYM<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> FLOWS_020100<br /> CREATE SYNONYM (With Admin Option)<br /> FLOWS_020100<br /> CREATE USER<br /> FLOWS_020100<br /> DBA (With Admin Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> FLOWS_020100<br /> DROP ANY DIRECTORY<br /> FLOWS_020100<br /> OBJ$ - SELECT<br /> FLOWS_020100<br /> RESOURCE (With Admin Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> FLOWS_020100<br /> SELECT_CATALOG_ROLE<br /> FLOWS_020100<br /> USER$ - SELECT (With Grant Option)<br /> FLOWS_FILES<br /> CONNECT<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> FLOWS_FILES<br /> CREATE ANY SYNONYM<br /> FLOWS_FILES<br /> CREATE PUBLIC SYNONYM<br /> FLOWS_FILES<br /> RESOURCE<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> HR<br /> CONNECT<br /> HR<br /> CREATE DATABASE LINK<br /> HR<br /> CREATE VIEW<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> HR<br /> RESOURCE<br /> HR<br /> UNLIMITED TABLESPACE<br /> sqle<br /> DBA<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> MDSYS<br /> CONNECT<br /> MDSYS<br /> CREATE OPERATOR<br /> MDSYS<br /> CREATE SEQUENCE<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> MDSYS<br /> CREATE TABLE<br /> MDSYS<br /> CREATE TYPE<br /> MDSYS<br /> CREATE VIEW<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> MDSYS<br /> DELETE ANY TABLE<br /> MDSYS<br /> RESOURCE<br /> MDSYS<br /> UNLIMITED TABLESPACE<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> OUTLN<br /> RESOURCE<br /> OUTLN<br /> UNLIMITED TABLESPACE<br /> PLSQL<br /> CONNECT<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> PLSQL<br /> CTXAPP<br /> PLSQL<br /> RESOURCE<br /> PLSQL<br /> UNLIMITED TABLESPACE<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYS<br /> ALTER ANY RULE (With Admin Option)<br /> SYS<br /> AQ_ADMINISTRATOR_ROLE (With Admin Option)<br /> SYS<br /> AQ_USER_ROLE (With Admin Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYS<br /> AUTHENTICATEDUSER (With Admin Option)<br /> SYS<br /> CONNECT (With Admin Option)<br /> SYS<br /> CREATE ANY EVALUATION CONTEXT (With Admin Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYS<br /> CREATE ANY RULE (With Admin Option)<br /> SYS<br /> CREATE RULE SET (With Admin Option)<br /> SYS<br /> CTXAPP (With Admin Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYS<br /> DBA (With Admin Option)<br /> SYS<br /> DELETE_CATALOG_ROLE (With Admin Option)<br /> SYS<br /> ENQUEUE ANY QUEUE (With Admin Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYS<br /> EXECUTE ANY EVALUATION CONTEXT (With Admin Option)<br /> SYS<br /> EXECUTE ANY PROCEDURE<br /> SYS<br /> EXECUTE ANY TYPE<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYS<br /> EXECUTE_CATALOG_ROLE (With Admin Option)<br /> SYS<br /> EXP_FULL_DATABASE (With Admin Option)<br /> SYS<br /> GATHER_SYSTEM_STATISTICS (With Admin Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYS<br /> HS_ADMIN_ROLE (With Admin Option)<br /> SYS<br /> IMP_FULL_DATABASE (With Admin Option)<br /> SYS<br /> INSERT ANY TABLE<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYS<br /> LOCK ANY TABLE<br /> SYS<br /> LOGSTDBY_ADMINISTRATOR (With Admin Option)<br /> SYS<br /> MANAGE ANY QUEUE (With Admin Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYS<br /> OEM_ADVISOR (With Admin Option)<br /> SYS<br /> OEM_MONITOR (With Admin Option)<br /> SYS<br /> PLUSTRACE (With Admin Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYS<br /> RECOVERY_CATALOG_OWNER (With Admin Option)<br /> SYS<br /> RESOURCE (With Admin Option)<br /> SYS<br /> SCHEDULER_ADMIN (With Admin Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYS<br /> SELECT ANY TABLE (With Admin Option)<br /> SYS<br /> SELECT_CATALOG_ROLE (With Admin Option)<br /> SYS<br /> UPDATE ANY TABLE<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYS<br /> XDBADMIN (With Admin Option)<br /> SYS<br /> XDBWEBSERVICES (With Admin Option)<br /> SYSTEM<br /> AQ_ADMINISTRATOR_ROLE (With Admin Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYSTEM<br /> CREATE MATERIALIZED VIEW<br /> SYSTEM<br /> CREATE TABLE<br /> SYSTEM<br /> DBA (With Admin Option)<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYSTEM<br /> GLOBAL QUERY REWRITE<br /> SYSTEM<br /> INCEXP - ALTER<br /> SYSTEM<br /> INCEXP - DEBUG<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYSTEM<br /> INCEXP - DELETE<br /> SYSTEM<br /> INCEXP - FLASHBACK<br /> SYSTEM<br /> INCEXP - INDEX<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYSTEM<br /> INCEXP - INSERT<br /> SYSTEM<br /> INCEXP - ON COMMIT REFRESH<br /> SYSTEM<br /> INCEXP - QUERY REWRITE<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYSTEM<br /> INCEXP - REFERENCES<br /> SYSTEM<br /> INCEXP - SELECT<br /> SYSTEM<br /> INCEXP - UPDATE<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYSTEM<br /> INCFIL - DEBUG<br /> SYSTEM<br /> INCFIL - DELETE<br /> SYSTEM<br /> INCFIL - FLASHBACK<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYSTEM<br /> INCFIL - INDEX<br /> SYSTEM<br /> INCFIL - INSERT<br /> SYSTEM<br /> INCFIL - ON COMMIT REFRESH<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYSTEM<br /> INCFIL - QUERY REWRITE<br /> SYSTEM<br /> INCFIL - REFERENCES<br /> SYSTEM<br /> INCFIL - SELECT<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYSTEM<br /> INCFIL - UPDATE<br /> SYSTEM<br /> INCVID - ALTER<br /> SYSTEM<br /> INCVID - DEBUG<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYSTEM<br /> INCVID - DELETE<br /> SYSTEM<br /> INCVID - FLASHBACK<br /> SYSTEM<br /> INCVID - INDEX<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYSTEM<br /> INCVID - INSERT<br /> SYSTEM<br /> INCVID - ON COMMIT REFRESH<br /> SYSTEM<br /> INCVID - QUERY REWRITE<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> SYSTEM<br /> INCVID - REFERENCES<br /> SYSTEM<br /> INCVID - SELECT<br /> SYSTEM<br /> INCVID - UPDATE<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> TSMSYS<br /> RESOURCE<br /> XDB<br /> CREATE INDEXTYPE<br /> XDB<br /> CREATE LIBRARY<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> XDB<br /> CREATE OPERATOR<br /> XDB<br /> CREATE PUBLIC SYNONYM<br /> XDB<br /> CTXAPP<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> XDB<br /> DROP PUBLIC SYNONYM<br /> XDB<br /> QUERY REWRITE<br /> XDB<br /> RESOURCE<br /> <br /> USERNAME<br /> ------------------------------<br /> WHAT_GRANTED<br /> --------------------------------------------------------------------------------<br /> XDB<br /> UNLIMITED TABLESPACE<br /> XDB<br /> USER$ - SELECT<br /> <br /> 143 rows selected.<br /> SQL&gt;<br /> SQL&gt;&lt;/source&gt;</div> Admin