ALL_DATA_GRANTS

ALL_DATA_GRANTS displays Oracle Deep Data Security (Deep Sec) data grants that are accessible to the current user.

This view displays data grants owned by the current user, as well as data grants owned by schemas on which the current user has the ADMINISTER ANY DATA GRANT or CREATE ANY DATA GRANT schema privilege. If the current user has the ADMINISTER ANY DATA GRANT or CREATE ANY DATA GRANT system privilege, then this view displays all data grants in the database.

Column Datatype NULL Description
OWNER VARCHAR2(128)   Owner of the data grant
GRANT_NAME VARCHAR2(128)   Name of the data grant
PRIVILEGE VARCHAR2(128)   Type of privilege granted
COLUMN_NAME VARCHAR2(128)  

Name of the column to which the data grant applies

Null if the granted privilege is not a column privilege.
GRANTED_WITH_ALL_COLUMNS_EXCEPT VARCHAR2(128)  

Name of the column to which the data grant applies, if granted using the ALL COLUMNS EXCEPT clause

Null if the granted privilege is not a column privilege or if the privilege was not granted using the ALL COLUMNS EXCEPT clause.

OBJECT_OWNER VARCHAR2(128)   Owner of the object to which the data grant applies
OBJECT_NAME VARCHAR2(128) NOT NULL Name of the object to which the data grant applies
OBJECT_TYPE VARCHAR2(24)   Type of object to which the data grant applies (such as TABLE, VIEW)
PREDICATE VARCHAR2(4000)   Predicate used for the data grant
GRANTEE VARCHAR2(128)  

Name of the grantee

This column is not applicable for cross-table data grants.
GRANTEE_TYPE VARCHAR2(30)  

Type of grantee:

  • DATA ROLE

  • END USER

This column is not applicable for cross-table data grants.
USE_DATA_GRANTS_ONLY BOOLEAN   Indicates whether USE DATA GRANTS ONLY is enabled for the object to which the data grant applies (TRUE) or not (FALSE)
CROSS_TABLE_DATA_GRANTFoot 1 BOOLEAN   Indicates whether the data grant is a cross-table data grant (TRUE) or not (FALSE)
START_TIME TIMESTAMP(6) WITH TIME ZONE  

Start time for the data grant, if specified

This column is not applicable for cross-table data grants.
END_TIME TIMESTAMP(6) WITH TIME ZONE  

End time for the data grant, if specified

This column is not applicable for cross-table data grants.
INVALID_COLUMN_NAME VARCHAR2(128)  

Displays the column name if the data grant on the column is no longer valid due to, for example, a column name change or a dropped column

Null if the granted privilege is not a column privilege or if the column is valid.

Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.3.

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

See Also: