SESSION_SCHEMA_PRIVS

SESSION_SCHEMA_PRIVS describes the schema privileges that are currently available to the user.

Column Datatype NULL Description
PRIVILEGE VARCHAR2(40) NOT NULL Schema privilege
SCHEMA VARCHAR2(128) NOT NULL Schema on which the privilege was granted

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