4.41 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.

Related Views

  • 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 NULL 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: