http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2FROLE_SYS_PRIVSOracle PL/SQL/System Tables Views/ROLE SYS PRIVS - История изменений2026-04-04T11:47:45ZИстория изменений этой страницы в викиMediaWiki 1.30.0http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/ROLE_SYS_PRIVS&diff=2172&oldid=prev в 13:45, 26 мая 20102010-05-26T13:45:19Z<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/System_Tables_Views/ROLE_SYS_PRIVS&diff=2173&oldid=prevAdmin: 1 версия2010-05-26T10:01:06Z<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Privileges assigned to roles and available to the currently logged in user==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> --Data Dictionary Views Describing Roles<br />
SQL><br />
SQL> --Privileges assigned to roles and available to the currently logged in user<br />
SQL><br />
SQL> desc ROLE_SYS_PRIVS;<br />
Name Null? Type<br />
----------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------<br />
ROLE NOT NULL VARCHAR2(30)<br />
PRIVILEGE NOT NULL VARCHAR2(40)<br />
ADMIN_OPTION VARCHAR2(3)<br />
SQL> select * from ROLE_SYS_PRIVS;<br />
ROLE PRIVILEGE ADM<br />
------------------------------ -------------------- ---<br />
DBA CREATE SESSION YES<br />
DBA ALTER SESSION YES<br />
DBA DROP TABLESPACE YES<br />
DBA BECOME USER YES<br />
DBA DROP ROLLBACK SEGMEN YES<br />
T<br />
DBA SELECT ANY TABLE YES<br />
DBA INSERT ANY TABLE YES<br />
DBA UPDATE ANY TABLE YES<br />
DBA DROP ANY INDEX YES<br />
DBA SELECT ANY SEQUENCE YES<br />
DBA CREATE ROLE YES<br />
DBA EXECUTE ANY PROCEDUR YES<br />
E<br />
DBA ALTER PROFILE YES<br />
DBA CREATE ANY DIRECTORY YES<br />
DBA CREATE ANY LIBRARY YES<br />
DBA EXECUTE ANY LIBRARY YES<br />
DBA ALTER ANY INDEXTYPE YES<br />
DBA DROP ANY INDEXTYPE YES<br />
DBA DEQUEUE ANY QUEUE YES<br />
DBA EXECUTE ANY EVALUATI YES<br />
ON CONTEXT<br />
DBA EXPORT FULL DATABASE YES<br />
DBA CREATE RULE YES<br />
DBA ALTER ANY SQL PROFIL YES<br />
E<br />
DBA ADMINISTER ANY SQL T YES<br />
UNING SET<br />
DBA CHANGE NOTIFICATION YES<br />
IMP_FULL_DATABASE BECOME USER NO<br />
IMP_FULL_DATABASE CREATE ANY MATERIALI NO<br />
ZED VIEW<br />
IMP_FULL_DATABASE CREATE ANY SYNONYM NO<br />
IMP_FULL_DATABASE EXECUTE ANY PROCEDUR NO<br />
E<br />
IMP_FULL_DATABASE DROP ANY TRIGGER NO<br />
IMP_FULL_DATABASE DROP ANY LIBRARY NO<br />
SCHEDULER_ADMIN CREATE ANY JOB YES<br />
EXP_FULL_DATABASE READ ANY FILE GROUP NO<br />
DBA ALTER ROLLBACK SEGME YES<br />
NT<br />
DBA DELETE ANY TABLE YES<br />
DBA ALTER DATABASE YES<br />
DBA FORCE ANY TRANSACTIO YES<br />
N<br />
DBA ALTER ANY PROCEDURE YES<br />
DBA DROP ANY TRIGGER YES<br />
DBA DROP ANY MATERIALIZE YES<br />
D VIEW<br />
DBA UNDER ANY TYPE YES<br />
DBA ALTER ANY LIBRARY YES<br />
DBA CREATE DIMENSION YES<br />
DBA DEBUG ANY PROCEDURE YES<br />
DBA CREATE RULE SET YES<br />
DBA ALTER ANY RULE SET YES<br />
DBA ANALYZE ANY DICTIONA YES<br />
RY<br />
IMP_FULL_DATABASE CREATE ANY CLUSTER NO<br />
IMP_FULL_DATABASE CREATE ANY INDEX NO<br />
IMP_FULL_DATABASE INSERT ANY TABLE NO<br />
IMP_FULL_DATABASE CREATE ANY LIBRARY NO<br />
IMP_FULL_DATABASE DROP ANY SEQUENCE NO<br />
IMP_FULL_DATABASE DROP ROLLBACK SEGMEN NO<br />
T<br />
IMP_FULL_DATABASE DROP ANY CONTEXT NO<br />
SCHEDULER_ADMIN EXECUTE ANY PROGRAM YES<br />
SCHEDULER_ADMIN EXECUTE ANY CLASS YES<br />
DBA RESTRICTED SESSION YES<br />
DBA CREATE TABLESPACE YES<br />
DBA ALTER TABLESPACE YES<br />
DBA CREATE USER YES<br />
DBA ALTER USER YES<br />
DBA LOCK ANY TABLE YES<br />
DBA CREATE VIEW YES<br />
DBA DROP ANY VIEW YES<br />
DBA GRANT ANY ROLE YES<br />
DBA CREATE TRIGGER YES<br />
DBA CREATE TYPE YES<br />
DBA EXECUTE ANY OPERATOR YES<br />
DBA CREATE ANY DIMENSION YES<br />
DBA ALTER ANY DIMENSION YES<br />
DBA CREATE ANY OUTLINE YES<br />
DBA ADMINISTER DATABASE YES<br />
TRIGGER<br />
ROLE PRIVILEGE ADM<br />
------------------------------ -------------------- ---<br />
DBA RESUMABLE YES<br />
DBA FLASHBACK ANY TABLE YES<br />
DBA CREATE ANY RULE SET YES<br />
DBA EXECUTE ANY RULE SET YES<br />
DBA IMPORT FULL DATABASE YES<br />
DBA EXECUTE ANY RULE YES<br />
DBA EXECUTE ANY PROGRAM YES<br />
EXP_FULL_DATABASE EXECUTE ANY PROCEDUR NO<br />
E<br />
EXP_FULL_DATABASE RESUMABLE NO<br />
IMP_FULL_DATABASE CREATE ANY PROCEDURE NO<br />
IMP_FULL_DATABASE CREATE ANY VIEW NO<br />
IMP_FULL_DATABASE CREATE TABLESPACE NO<br />
IMP_FULL_DATABASE SELECT ANY TABLE NO<br />
IMP_FULL_DATABASE CREATE ANY CONTEXT NO<br />
IMP_FULL_DATABASE CREATE ANY OPERATOR NO<br />
IMP_FULL_DATABASE GLOBAL QUERY REWRITE NO<br />
IMP_FULL_DATABASE DROP ANY OUTLINE NO<br />
IMP_FULL_DATABASE DROP ANY VIEW NO<br />
IMP_FULL_DATABASE DROP PROFILE NO<br />
IMP_FULL_DATABASE DROP USER NO<br />
IMP_FULL_DATABASE DROP ANY TYPE NO<br />
DBA CREATE ANY TABLE YES<br />
DBA CREATE ANY INDEX YES<br />
DBA CREATE ANY SEQUENCE YES<br />
DBA ALTER ANY ROLE YES<br />
DBA ANALYZE ANY YES<br />
DBA DROP ANY LIBRARY YES<br />
DBA CREATE ANY OPERATOR YES<br />
DBA CREATE INDEXTYPE YES<br />
DBA UNDER ANY TABLE YES<br />
DBA DROP ANY DIMENSION YES<br />
DBA SELECT ANY DICTIONAR YES<br />
Y<br />
DBA GRANT ANY OBJECT PRI YES<br />
VILEGE<br />
DBA CREATE EVALUATION CO YES<br />
NTEXT<br />
DBA CREATE ANY EVALUATIO YES<br />
N CONTEXT<br />
DBA DROP ANY EVALUATION YES<br />
CONTEXT<br />
DBA CREATE ANY RULE YES<br />
DBA CREATE JOB YES<br />
DBA CREATE ANY JOB YES<br />
EXP_FULL_DATABASE SELECT ANY TABLE NO<br />
EXP_FULL_DATABASE EXECUTE ANY TYPE NO<br />
IMP_FULL_DATABASE CREATE PUBLIC DATABA NO<br />
SE LINK<br />
IMP_FULL_DATABASE CREATE PUBLIC SYNONY NO<br />
M<br />
IMP_FULL_DATABASE CREATE ROLLBACK SEGM NO<br />
ENT<br />
IMP_FULL_DATABASE CREATE ROLE NO<br />
IMP_FULL_DATABASE DROP ANY INDEX NO<br />
IMP_FULL_DATABASE DROP ANY TABLE NO<br />
IMP_FULL_DATABASE DROP ANY MATERIALIZE NO<br />
D VIEW<br />
IMP_FULL_DATABASE DROP ANY ROLE NO<br />
IMP_FULL_DATABASE ALTER ANY TYPE NO<br />
IMP_FULL_DATABASE MANAGE ANY QUEUE NO<br />
DBA ALTER SYSTEM YES<br />
DBA AUDIT SYSTEM YES<br />
DBA CREATE ROLLBACK SEGM YES<br />
ENT<br />
DBA DROP ANY TABLE YES<br />
DBA COMMENT ANY TABLE YES<br />
DBA CREATE CLUSTER YES<br />
DBA ALTER ANY INDEX YES<br />
DBA DROP PUBLIC DATABASE YES<br />
LINK<br />
DBA CREATE PROFILE YES<br />
DBA ALTER ANY MATERIALIZ YES<br />
ED VIEW<br />
DBA ALTER ANY TYPE YES<br />
DBA DROP ANY TYPE YES<br />
DBA UNDER ANY VIEW YES<br />
DBA EXECUTE ANY INDEXTYP YES<br />
E<br />
DBA DROP ANY CONTEXT YES<br />
DBA ALTER ANY OUTLINE YES<br />
DBA ADMINISTER RESOURCE YES<br />
ROLE PRIVILEGE ADM<br />
------------------------------ -------------------- ---<br />
MANAGER<br />
DBA MANAGE SCHEDULER YES<br />
DBA MANAGE FILE GROUP YES<br />
EXP_FULL_DATABASE BACKUP ANY TABLE NO<br />
IMP_FULL_DATABASE CREATE PROFILE NO<br />
IMP_FULL_DATABASE COMMENT ANY TABLE NO<br />
IMP_FULL_DATABASE CREATE ANY INDEXTYPE NO<br />
IMP_FULL_DATABASE CREATE ANY DIMENSION NO<br />
IMP_FULL_DATABASE DROP ANY CLUSTER NO<br />
IMP_FULL_DATABASE DROP ANY PROCEDURE NO<br />
IMP_FULL_DATABASE DROP PUBLIC SYNONYM NO<br />
IMP_FULL_DATABASE DROP ANY DIRECTORY NO<br />
EXP_FULL_DATABASE ADMINISTER RESOURCE NO<br />
MANAGER<br />
DBA CREATE TABLE YES<br />
DBA BACKUP ANY TABLE YES<br />
DBA CREATE ANY CLUSTER YES<br />
DBA DROP ANY SYNONYM YES<br />
DBA DROP PUBLIC SYNONYM YES<br />
DBA CREATE ANY VIEW YES<br />
DBA CREATE SEQUENCE YES<br />
DBA ALTER ANY SEQUENCE YES<br />
DBA FORCE TRANSACTION YES<br />
DBA CREATE PROCEDURE YES<br />
DBA CREATE ANY PROCEDURE YES<br />
DBA ALTER RESOURCE COST YES<br />
DBA DROP ANY DIRECTORY YES<br />
DBA CREATE ANY TYPE YES<br />
DBA CREATE ANY INDEXTYPE YES<br />
DBA ENQUEUE ANY QUEUE YES<br />
DBA ON COMMIT REFRESH YES<br />
DBA DEBUG CONNECT SESSIO YES<br />
N<br />
DBA DROP ANY RULE SET YES<br />
DBA EXECUTE ANY CLASS YES<br />
DBA MANAGE ANY FILE GROU YES<br />
P<br />
EXP_FULL_DATABASE SELECT ANY SEQUENCE NO<br />
IMP_FULL_DATABASE EXECUTE ANY TYPE NO<br />
IMP_FULL_DATABASE UPDATE ANY TABLE NO<br />
IMP_FULL_DATABASE CREATE ANY DIRECTORY NO<br />
IMP_FULL_DATABASE CREATE ANY TYPE NO<br />
IMP_FULL_DATABASE DROP ANY SYNONYM NO<br />
IMP_FULL_DATABASE DROP PUBLIC DATABASE NO<br />
LINK<br />
IMP_FULL_DATABASE DROP TABLESPACE NO<br />
IMP_FULL_DATABASE ALTER ANY TRIGGER NO<br />
IMP_FULL_DATABASE DROP ANY INDEXTYPE NO<br />
IMP_FULL_DATABASE DROP ANY DIMENSION NO<br />
IMP_FULL_DATABASE ANALYZE ANY NO<br />
IMP_FULL_DATABASE ADMINISTER RESOURCE NO<br />
MANAGER<br />
SCHEDULER_ADMIN MANAGE SCHEDULER YES<br />
SCHEDULER_ADMIN CREATE EXTERNAL JOB YES<br />
DBA ALTER ANY TABLE YES<br />
DBA DROP ANY CLUSTER YES<br />
DBA CREATE SYNONYM YES<br />
DBA CREATE PUBLIC SYNONY YES<br />
M<br />
DBA DROP ANY SEQUENCE YES<br />
DBA DROP ANY ROLE YES<br />
DBA AUDIT ANY YES<br />
DBA DROP ANY PROCEDURE YES<br />
DBA CREATE ANY TRIGGER YES<br />
DBA ALTER ANY TRIGGER YES<br />
DBA DROP PROFILE YES<br />
DBA GRANT ANY PRIVILEGE YES<br />
DBA CREATE LIBRARY YES<br />
DBA CREATE OPERATOR YES<br />
DBA DROP ANY OUTLINE YES<br />
DBA MERGE ANY VIEW YES<br />
DBA ADMINISTER SQL TUNIN YES<br />
G SET<br />
IMP_FULL_DATABASE CREATE ANY TABLE NO<br />
IMP_FULL_DATABASE CREATE DATABASE LINK NO<br />
IMP_FULL_DATABASE CREATE USER NO<br />
IMP_FULL_DATABASE AUDIT ANY NO<br />
IMP_FULL_DATABASE CREATE ANY SQL PROFI NO<br />
LE<br />
IMP_FULL_DATABASE ALTER ANY PROCEDURE NO<br />
IMP_FULL_DATABASE DROP ANY OPERATOR NO<br />
IMP_FULL_DATABASE RESUMABLE NO<br />
IMP_FULL_DATABASE DROP ANY SQL PROFILE NO<br />
DBA MANAGE TABLESPACE YES<br />
DBA DROP USER YES<br />
DBA ALTER ANY CLUSTER YES<br />
DBA CREATE ANY SYNONYM YES<br />
DBA CREATE DATABASE LINK YES<br />
ROLE PRIVILEGE ADM<br />
------------------------------ -------------------- ---<br />
DBA CREATE PUBLIC DATABA YES<br />
SE LINK<br />
DBA CREATE MATERIALIZED YES<br />
VIEW<br />
DBA CREATE ANY MATERIALI YES<br />
ZED VIEW<br />
DBA EXECUTE ANY TYPE YES<br />
DBA DROP ANY OPERATOR YES<br />
DBA QUERY REWRITE YES<br />
DBA GLOBAL QUERY REWRITE YES<br />
DBA MANAGE ANY QUEUE YES<br />
DBA CREATE ANY CONTEXT YES<br />
DBA ALTER ANY EVALUATION YES<br />
CONTEXT<br />
DBA ALTER ANY RULE YES<br />
DBA DROP ANY RULE YES<br />
DBA ADVISOR YES<br />
DBA SELECT ANY TRANSACTI YES<br />
ON<br />
DBA DROP ANY SQL PROFILE YES<br />
DBA CREATE ANY SQL PROFI YES<br />
LE<br />
DBA READ ANY FILE GROUP YES<br />
DBA CREATE EXTERNAL JOB YES<br />
IMP_FULL_DATABASE CREATE ANY SEQUENCE NO<br />
IMP_FULL_DATABASE CREATE ANY TRIGGER NO<br />
IMP_FULL_DATABASE ALTER ANY TABLE NO<br />
IMP_FULL_DATABASE ADMINISTER DATABASE NO<br />
TRIGGER<br />
SCHEDULER_ADMIN CREATE JOB YES<br />
242 rows selected.<br />
SQL><br />
SQL><br />
<br />
</source></div>Admin