DBA Data[Home] [Help] [Dependency Information]

TABLE: SYS.SYSTEM_PRIVILEGE_MAP

Object Details
Object Name: SYSTEM_PRIVILEGE_MAP
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Description table for privilege type codes. Maps privilege type numbers to type names

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_SYSTEM_PRIVILEGE_MAP NORMAL UNIQUE TablespaceSYSTEM ColumnPRIVILEGE
ColumnNAME
Columns
Name Datatype Length Mandatory Comments
PRIVILEGE NUMBER
Yes Numeric privilege type code
NAME VARCHAR2 (40) Yes Name of the type of privilege
PROPERTY NUMBER
Yes Property flag of privilege like not export this privilege, etc
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PRIVILEGE
,      NAME
,      PROPERTY
FROM SYS.SYSTEM_PRIVILEGE_MAP;

Dependencies

[top of page]

SYS.SYSTEM_PRIVILEGE_MAP does not reference any database object

SYS.SYSTEM_PRIVILEGE_MAP is referenced by following:

SchemaDVSYS
ViewDBA_DV_USER_PRIVS_ALL
SchemaPUBLIC
SynonymSYSTEM_PRIVILEGE_MAP
SchemaSYS
ViewALL_REFRESH
ViewALL_REFRESH_CHILDREN
ViewAUDIT_UNIFIED_POLICIES
ViewDBA_AUDIT_TRAIL
ViewDBA_COMMON_AUDIT_TRAIL
ViewDBA_PRIV_AUDIT_OPTS
ViewDBA_RSRC_MANAGER_SYSTEM_PRIVS
ViewDBA_SYS_PRIVS
ViewDBA_UNUSED_PRIVS
ViewDBA_USED_PRIVS
Package BodyDBMS_LOGREP_UTIL - show dependent code
Package BodyDBMS_PRIV_CAPTURE - show dependent code
Package BodyDBMS_SQLTUNE_UTIL2 - show dependent code
ViewEXPEXEMPT
ViewEXU7SPV
ViewEXU8SPV
ViewKU$_AUDIT_POLICY_VIEW
ViewKU$_SYSGRANT_VIEW
Package BodyPRVTEMX_ADMIN - show dependent code
ViewROLE_SYS_PRIVS
ViewSESSION_PRIVS
ViewUNIFIED_AUDIT_TRAIL
ViewUSER_RSRC_MANAGER_SYSTEM_PRIVS
ViewUSER_SYS_PRIVS