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

Related Views

  • DBA_DATA_GRANTS displays all Deep Sec data grants in the database.

  • USER_DATA_GRANTS displays Deep Sec data grants that are owned by the current user. This view does not display the OWNER column.

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

GRANTEE_TYPE

VARCHAR2(30)

Type of grantee:

  • DATA ROLE

  • END USER

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)

START_TIME

TIMESTAMP(6) WITH TIME ZONE

Start time for the data grant, if specified

END_TIME

TIMESTAMP(6) WITH TIME ZONE

End time for the data grant, if specified

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.

Note:

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

See Also: