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

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 Database 23ai.