V$ENABLEDPRIVS

7.198 V$ENABLEDPRIVS

V$ENABLEDPRIVS displays the system privileges that have been granted to the current user and the currently enabled roles. These privileges can be found in the table SYSTEM_PRIVILEGE_MAP.

Column Datatype Description

Column	Datatype	Description
`PRIV_NUMBER`	`NUMBER`	Numeric identifier of the system privilege
`SCOPE`	`VARCHAR2(11)`	Indicates the scope with which a privilege was granted. Possible values: `COMMON` `APPLICATION` `LOCAL` `NULL` (if connected to a non-CDB )
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

PRIV_NUMBER

NUMBER

Numeric identifier of the system privilege

SCOPE

VARCHAR2(11)

Indicates the scope with which a privilege was granted. Possible values:

COMMON
APPLICATION
LOCAL
NULL (if connected to a non-CDB )

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
1: This value is used for rows containing data that pertain to only the root
n: Where n is the applicable container ID for the rows containing data