http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2Fdba_role_privs
Oracle PL/SQL Tutorial/System Tables Data Dictionary/dba role privs - История изменений
2026-05-24T11:34:55Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/dba_role_privs&diff=3875&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://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/dba_role_privs&diff=3876&oldid=prev
Admin: 1 версия
2010-05-26T10:08:03Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Direct Role Grants to Users==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL> SELECT b.granted_role ||<br />
2 DECODE(admin_option, "YES",<br />
3 " (With Admin Option)",<br />
4 NULL) what_granted, a.username<br />
5 FROM sys.dba_users a, sys.dba_role_privs b<br />
6 WHERE a.username = b.grantee<br />
7 and rownum < 50<br />
8 ORDER BY 1;<br />
WHAT_GRANTED<br />
--------------------------------------------------<br />
USERNAME<br />
------------------------------<br />
AQ_ADMINISTRATOR_ROLE (With Admin Option)<br />
SYSTEM<br />
AQ_ADMINISTRATOR_ROLE (With Admin Option)<br />
SYS<br />
AQ_USER_ROLE (With Admin Option)<br />
SYS<br />
<br />
WHAT_GRANTED<br />
--------------------------------------------------<br />
USERNAME<br />
------------------------------<br />
AUTHENTICATEDUSER (With Admin Option)<br />
SYS<br />
CONNECT<br />
MDSYS<br />
CONNECT<br />
PLSQL<br />
<br />
WHAT_GRANTED<br />
--------------------------------------------------<br />
USERNAME<br />
------------------------------<br />
CONNECT<br />
HR<br />
CONNECT<br />
FLOWS_FILES<br />
CONNECT (With Admin Option)<br />
SYS<br />
<br />
WHAT_GRANTED<br />
--------------------------------------------------<br />
USERNAME<br />
------------------------------<br />
CONNECT (With Admin Option)<br />
FLOWS_020100<br />
CTXAPP<br />
PLSQL<br />
CTXAPP<br />
XDB<br />
<br />
WHAT_GRANTED<br />
--------------------------------------------------<br />
USERNAME<br />
------------------------------<br />
CTXAPP (With Admin Option)<br />
CTXSYS<br />
CTXAPP (With Admin Option)<br />
SYS<br />
DBA<br />
sqle<br />
<br />
WHAT_GRANTED<br />
--------------------------------------------------<br />
USERNAME<br />
------------------------------<br />
DBA (With Admin Option)<br />
FLOWS_020100<br />
DBA (With Admin Option)<br />
SYS<br />
DBA (With Admin Option)<br />
SYSTEM<br />
<br />
WHAT_GRANTED<br />
--------------------------------------------------<br />
USERNAME<br />
------------------------------<br />
DELETE_CATALOG_ROLE (With Admin Option)<br />
SYS<br />
EXECUTE_CATALOG_ROLE (With Admin Option)<br />
SYS<br />
EXP_FULL_DATABASE (With Admin Option)<br />
SYS<br />
<br />
WHAT_GRANTED<br />
--------------------------------------------------<br />
USERNAME<br />
------------------------------<br />
GATHER_SYSTEM_STATISTICS (With Admin Option)<br />
SYS<br />
HS_ADMIN_ROLE (With Admin Option)<br />
SYS<br />
IMP_FULL_DATABASE (With Admin Option)<br />
SYS<br />
<br />
WHAT_GRANTED<br />
--------------------------------------------------<br />
USERNAME<br />
------------------------------<br />
LOGSTDBY_ADMINISTRATOR (With Admin Option)<br />
SYS<br />
OEM_ADVISOR (With Admin Option)<br />
SYS<br />
OEM_MONITOR<br />
DBSNMP<br />
<br />
WHAT_GRANTED<br />
--------------------------------------------------<br />
USERNAME<br />
------------------------------<br />
OEM_MONITOR (With Admin Option)<br />
SYS<br />
PLUSTRACE (With Admin Option)<br />
SYS<br />
RECOVERY_CATALOG_OWNER (With Admin Option)<br />
SYS<br />
<br />
WHAT_GRANTED<br />
--------------------------------------------------<br />
USERNAME<br />
------------------------------<br />
RESOURCE<br />
HR<br />
RESOURCE<br />
FLOWS_FILES<br />
RESOURCE<br />
PLSQL<br />
<br />
WHAT_GRANTED<br />
--------------------------------------------------<br />
USERNAME<br />
------------------------------<br />
RESOURCE<br />
CTXSYS<br />
RESOURCE<br />
XDB<br />
RESOURCE<br />
MDSYS<br />
<br />
WHAT_GRANTED<br />
--------------------------------------------------<br />
USERNAME<br />
------------------------------<br />
RESOURCE<br />
OUTLN<br />
RESOURCE<br />
TSMSYS<br />
RESOURCE (With Admin Option)<br />
FLOWS_020100<br />
<br />
WHAT_GRANTED<br />
--------------------------------------------------<br />
USERNAME<br />
------------------------------<br />
RESOURCE (With Admin Option)<br />
SYS<br />
SCHEDULER_ADMIN (With Admin Option)<br />
SYS<br />
SELECT_CATALOG_ROLE<br />
FLOWS_020100<br />
<br />
WHAT_GRANTED<br />
--------------------------------------------------<br />
USERNAME<br />
------------------------------<br />
SELECT_CATALOG_ROLE (With Admin Option)<br />
SYS<br />
XDBADMIN (With Admin Option)<br />
SYS<br />
XDBWEBSERVICES (With Admin Option)<br />
SYS<br />
<br />
45 rows selected.<br />
SQL><br />
SQL></source><br />
<br />
<br />
<br />
== Query DBA_ROLE_PRIVS, ROLE_TAB_PRIVS for Name of the object, Privilege granted,Was admin option granted==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL> select<br />
4 ROLE_TAB_PRIVS.Table_Name, /*Name of the object*/<br />
5 ROLE_TAB_PRIVS.Privilege, /*Privilege granted*/<br />
6 ROLE_TAB_PRIVS.Grantable /*Was admin option granted?*/<br />
7 from DBA_ROLE_PRIVS, ROLE_TAB_PRIVS<br />
8 where DBA_ROLE_PRIVS.Granted_Role = ROLE_TAB_PRIVS.Role<br />
9 and DBA_ROLE_PRIVS.Grantee = "some username";<br />
SQL><br />
SQL><br />
SQL></source></div>
Admin