 |
|
DBA_SYS_PRIVS view tips
Oracle Tips by Burleson Consulting |
DBA_SYS_PRIVS
<< Return to the index
Oracle 11g makes the following comments about the DBA_SYS_PRIVS table: "System privileges granted to users and roles"
Related notes on DBA_SYS_PRIVS:
Column description of the DBA_SYS_PRIVS view:GRANTEEDescription of DBA_SYS_PRIVS.GRANTEE: "Grantee Name, User or Role receiving the grant" PRIVILEGEDescription of DBA_SYS_PRIVS.PRIVILEGE: "System privilege" ADMIN_OPTIONDescription of DBA_SYS_PRIVS.ADMIN_OPTION: "Grant was with the ADMIN option"
DBA_SYS_PRIVS View SourceOracle 11g's data dictionary defines the DBA_SYS_PRIVS view using the following source query:
select u.name,spm.name,decode(min(option$),1,'YES','NO')
from sys.system_privilege_map spm, sys.sysauth$ sa, user$ u
where sa.grantee#=u.user# and sa.privilege#=spm.privilege
group by u.name,spm.name
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
