USER_SCHEMA_PRIVS

USER_SCHEMA_PRIVS describes schema privileges granted to the current user.

Column	Datatype	Description
`USERNAME`	`VARCHAR2(128)`	Name of the user, or `PUBLIC`
`PRIVILEGE`	`VARCHAR2(40)`	Schema privilege
`SCHEMA`	`VARCHAR2(128)`	Schema on which the privilege was granted
`ADMIN_OPTION`	`VARCHAR2(3)`	Indicates whether the grant was with the `ADMIN` option (`YES`) or not (`NO`)
`COMMON`	`VARCHAR2(3)`	Indicates how the grant was made. Possible values: `YES` if the privilege was granted commonly (`CONTAINER=ALL` was used) `NO` if the privilege was granted locally (`CONTAINER=ALL` was not used)
`INHERITED`	`VARCHAR2(3)`	Indicates whether the grant was inherited from another container (`YES`) or not (`NO`)

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

See Also: “DBA_SCHEMA_PRIVS”