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

VIEW: SYS.CDB_LOCAL_ADMIN_PRIVS

Object Details
Object Name: CDB_LOCAL_ADMIN_PRIVS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Describes local administrative privileges granted in PDBs of a CDB

[View Source]

Columns
Name Datatype Length Mandatory Comments
CON_ID NUMBER
Yes ID of a Container in which a privilege was granted
CON_NAME VARCHAR2 (128) Yes Name of a Container in which a privilege was granted
GRANTEE VARCHAR2 (128) Yes Name of a grantee to whom privilege(s) were granted
SYSDBA VARCHAR2 (5)
SYSDBA privilege was granted
SYSOPER VARCHAR2 (5)
SYSOPER privilege was granted
SYSASM VARCHAR2 (5)
SYSASM privilege was granted
SYSBACKUP VARCHAR2 (5)
SYSBACKUP privilege was granted
SYSDG VARCHAR2 (5)
SYSDG privilege was granted
SYSKM VARCHAR2 (5)
SYSKM privilege was granted
Query Text

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


SELECT CON_ID
,      CON_NAME
,      GRANTEE
,      SYSDBA
,      SYSOPER
,      SYSASM
,      SYSBACKUP
,      SYSDG
,      SYSKM
FROM SYS.CDB_LOCAL_ADMIN_PRIVS;

Dependencies

[top of page]

SYS.CDB_LOCAL_ADMIN_PRIVS references the following:

SchemaSYS
TableCDB_LOCAL_ADMINAUTH$
TableCONTAINER$
TableOBJ$
SYS.CDB_LOCAL_ADMIN_PRIVS is referenced by following:

SchemaPUBLIC
SynonymCDB_LOCAL_ADMIN_PRIVS