SESSION_PRIVS

7.263 SESSION_PRIVS_ALL

SESSION_PRIVS_ALL describes the system privileges and schema privileges that are currently available to the user.

Column Datatype NULL Description

Column	Datatype	NULL	Description
`PRIVILEGE`	`VARCHAR2(40)`		Name of the privilege
`SCHEMA`	`VARCHAR2(128)`		Schema on which the privilege was granted For system privileges, the value of this column is null.

PRIVILEGE

VARCHAR2(40)

Name of the privilege

SCHEMA

VARCHAR2(128)

Schema on which the privilege was granted

For system privileges, the value of this column is null.

Note:

This view is available starting with Oracle AI Database 26ai.