| |
 |
|
DBA_COL_PRIVS view tips
Oracle Tips by Burleson Consulting |
DBA_COL_PRIVS
<< Return to the index
Oracle 11g makes the following comments about the DBA_COL_PRIVS table: "All grants on columns in the database"
Related notes on DBA_COL_PRIVS:
Column description of the DBA_COL_PRIVS view:GRANTEEDescription of DBA_COL_PRIVS.GRANTEE: "Name of the user to whom access was granted" OWNERDescription of DBA_COL_PRIVS.OWNER: "Username of the owner of the object" TABLE_NAMEDescription of DBA_COL_PRIVS.TABLE_NAME: "Name of the object" COLUMN_NAMEDescription of DBA_COL_PRIVS.COLUMN_NAME: "Name of the column" GRANTORDescription of DBA_COL_PRIVS.GRANTOR: "Name of the user who performed the grant" PRIVILEGEDescription of DBA_COL_PRIVS.PRIVILEGE: "Column Privilege" GRANTABLEDescription of DBA_COL_PRIVS.GRANTABLE: "Privilege is grantable"
DBA_COL_PRIVS View SourceOracle 11g's data dictionary defines the DBA_COL_PRIVS view using the following source query:
select ue.name, u.name, o.name, c.name, ur.name, tpm.name,
decode(mod(oa.option$,2), 1, 'YES', 'NO')
from sys.objauth$ oa, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u, sys.user$ ur,
sys.user$ ue, sys.col$ c, table_privilege_map tpm
where oa.obj# = o.obj#
and oa.grantor# = ur.user#
and oa.grantee# = ue.user#
and oa.obj# = c.obj#
and oa.col# = c.col#
and bitand(c.property, 32) = 0 /* not hidden column */
and oa.col# is not null
and oa.privilege# = tpm.privilege
and u.user# = o.owner#
 |
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
|
|
