http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2Fdba_sys_privs
Oracle PL/SQL/System Tables Views/dba sys privs - История изменений
2026-05-24T03:42:31Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/dba_sys_privs&diff=2278&oldid=prev
в 13:45, 26 мая 2010
2010-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://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/dba_sys_privs&diff=2279&oldid=prev
Admin: 1 версия
2010-05-26T10:01:18Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Query dba_sys_privs table==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> set verify off<br />
SQL><br />
SQL> column priv format a30 heading "Privilege"<br />
SQL> column wadmin format a6 heading "Admin?"<br />
SQL><br />
SQL> select privilege priv, initcap(admin_option) wadmin<br />
2 from dba_sys_privs<br />
3 where rownum < 50<br />
4 /<br />
Privilege Admin?<br />
------------------------------ ------<br />
CREATE VIEW No<br />
ALTER SESSION No<br />
CREATE SESSION No<br />
CREATE SYNONYM No<br />
CREATE SEQUENCE No<br />
CREATE DATABASE LINK No<br />
UNLIMITED TABLESPACE No<br />
ADVISOR Yes<br />
AUDIT ANY Yes<br />
DROP USER Yes<br />
RESUMABLE Yes<br />
ALTER USER Yes<br />
CREATE JOB Yes<br />
ANALYZE ANY Yes<br />
BECOME USER Yes<br />
CREATE ROLE Yes<br />
CREATE RULE Yes<br />
CREATE TYPE Yes<br />
CREATE USER Yes<br />
CREATE VIEW Yes<br />
ALTER SYSTEM Yes<br />
AUDIT SYSTEM Yes<br />
CREATE TABLE Yes<br />
DROP PROFILE Yes<br />
ALTER PROFILE Yes<br />
ALTER SESSION Yes<br />
DROP ANY ROLE Yes<br />
DROP ANY RULE Yes<br />
DROP ANY TYPE Yes<br />
DROP ANY VIEW Yes<br />
QUERY REWRITE Yes<br />
ALTER ANY ROLE Yes<br />
ALTER ANY RULE Yes<br />
ALTER ANY TYPE Yes<br />
ALTER DATABASE Yes<br />
CREATE ANY JOB Yes<br />
CREATE CLUSTER Yes<br />
CREATE LIBRARY Yes<br />
CREATE PROFILE Yes<br />
CREATE SESSION Yes<br />
CREATE SYNONYM Yes<br />
CREATE TRIGGER Yes<br />
DROP ANY INDEX Yes<br />
DROP ANY TABLE Yes<br />
GRANT ANY ROLE Yes<br />
LOCK ANY TABLE Yes<br />
MERGE ANY VIEW Yes<br />
UNDER ANY TYPE Yes<br />
UNDER ANY VIEW Yes<br />
49 rows selected.<br />
SQL><br />
SQL> --<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==select distinct privilege from dba_sys_privs==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
VARCHAR2(3)<br />
SQL> select distinct privilege<br />
2 from dba_sys_privs<br />
3 where rownum < 50<br />
4 order by privilege;<br />
PRIVILEGE<br />
----------------------------------------<br />
ADVISOR<br />
ALTER SYSTEM<br />
ALTER USER<br />
ANALYZE ANY<br />
AUDIT ANY<br />
AUDIT SYSTEM<br />
BECOME USER<br />
CREATE JOB<br />
CREATE ROLE<br />
CREATE RULE<br />
CREATE TABLE<br />
PRIVILEGE<br />
----------------------------------------<br />
CREATE TYPE<br />
CREATE USER<br />
CREATE VIEW<br />
DROP USER<br />
RESUMABLE<br />
16 rows selected.<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==User System Privileges==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> SET FEEDBACK OFF<br />
SQL> SET PAGESIZE 20<br />
SQL> SET LINESIZE 77<br />
SQL> SET HEADING ON<br />
SQL><br />
SQL> COLUMN username FORMAT A12 HEADING "User"<br />
SQL> COLUMN privilege FORMAT A20 HEADING "Privilege"<br />
SQL> TTITLE LEFT "User System Privileges" RIGHT "Page " FORMAT 999 SQL.PNO SKIP 2<br />
SQL><br />
SQL> SELECT username, privilege<br />
2 FROM dba_users, dba_sys_privs<br />
3 WHERE username = grantee<br />
4 ORDER BY username, privilege;<br />
User System Privileges Page 1<br />
User Privilege<br />
------------ --------------------<br />
ANONYMOUS CREATE SESSION<br />
CTXSYS ALTER SESSION<br />
CTXSYS CREATE PUBLIC SYNONY<br />
M<br />
CTXSYS CREATE SESSION<br />
CTXSYS CREATE SYNONYM<br />
CTXSYS CREATE VIEW<br />
CTXSYS DROP PUBLIC SYNONYM<br />
CTXSYS UNLIMITED TABLESPACE<br />
DBSNMP CREATE PROCEDURE<br />
DBSNMP CREATE TABLE<br />
DBSNMP SELECT ANY DICTIONAR<br />
Y<br />
<br />
User System Privileges Page 2<br />
User Privilege<br />
------------ --------------------<br />
DBSNMP UNLIMITED TABLESPACE<br />
DEFINER UNLIMITED TABLESPACE<br />
DIP CREATE SESSION<br />
FLOWS_020100 ALTER DATABASE<br />
FLOWS_020100 ALTER SESSION<br />
FLOWS_020100 ALTER SYSTEM<br />
FLOWS_020100 ALTER USER<br />
FLOWS_020100 CREATE ANY CONTEXT<br />
FLOWS_020100 CREATE ANY DIRECTORY<br />
FLOWS_020100 CREATE CLUSTER<br />
FLOWS_020100 CREATE DATABASE LINK<br />
FLOWS_020100 CREATE DIMENSION<br />
FLOWS_020100 CREATE INDEXTYPE<br />
FLOWS_020100 CREATE JOB<br />
FLOWS_020100 CREATE LIBRARY<br />
User System Privileges Page 3<br />
User Privilege<br />
------------ --------------------<br />
FLOWS_020100 CREATE MATERIALIZED<br />
VIEW<br />
FLOWS_020100 CREATE OPERATOR<br />
FLOWS_020100 CREATE PROCEDURE<br />
FLOWS_020100 CREATE PUBLIC SYNONY<br />
M<br />
FLOWS_020100 CREATE ROLE<br />
FLOWS_020100 CREATE SEQUENCE<br />
FLOWS_020100 CREATE SYNONYM<br />
FLOWS_020100 CREATE TABLE<br />
FLOWS_020100 CREATE TABLESPACE<br />
FLOWS_020100 CREATE TRIGGER<br />
FLOWS_020100 CREATE TYPE<br />
SQL><br />
SQL> SET FEEDBACK ON<br />
<br />
<br />
<br />
<br />
</source></div>
Admin