ALL_REQUIRED_PARENT_DATA_PRIVILEGES

ALL_REQUIRED_PARENT_DATA_PRIVILEGES displays parent object privileges required by cross-table data grants accessible to the current user.

A cross-table data grant is accessible to the current user when any of the following is true:

The current user is the owner of the data grant.
The current user has the ADMINISTER ANY DATA GRANT system privilege, which results in all cross-table data grants being displayed.
The current user has the ADMINISTER ANY DATA GRANT privilege at the schema level on the schema of the object on which the data grant is created, which results in the cross-table data grants in those schemas being displayed.

DBA_REQUIRED_PARENT_DATA_PRIVILEGES displays parent object privileges required by all cross-table data grants in the database.
USER_REQUIRED_PARENT_DATA_PRIVILEGES displays parent object privileges required by cross-table data grants owned by the current user. This view does not display the OWNER column.

Column	Datatype	Description
`OWNER`	`VARCHAR2(128)`	Owner of the cross-table data grant
`GRANT_NAME`	`VARCHAR2(128)`	Name of the cross-table data grant
`PRIVILEGE`	`VARCHAR2(128)`	Privilege required on the parent object: `DELETE` `INSERT` `SELECT` `UPDATE`
`COLUMN_NAME`	`VARCHAR2(128)`	Name of the parent object column on which the privilege is required There is one row for each column name specified in the required privilege. Null if the required privilege is not a column privilege.
`CROSS_TABLE_OBJECT_OWNER`	`VARCHAR2(128)`	Owner of the parent object
`CROSS_TABLE_OBJECT_NAME`	`VARCHAR2(128)`	Name of the parent object
`CROSS_TABLE_OBJECT_TYPE`	`VARCHAR2(24)`	Type of the parent object (such as `TABLE` or `VIEW`)
`INVALID_COLUMN_NAME`	`VARCHAR2(128)`	Name of the parent object column that is no longer valid because of a schema change (for example, a dropped or renamed column) Null if the column is valid or if no column is specified.

Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.26.3.

See Also:

Related Views