TABLE_PRIVILEGES
Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above Unity Catalog only
INFORMATION_SCHEMA.TABLE_PRIVILEGES lists principals that have privileges on a table in a catalog schema.
Definition
The TABLE_PRIVILEGES
relation contains the following columns:
Name |
Data type |
Nullable |
Standard |
Description |
---|---|---|---|---|
|
|
No |
Yes |
Principal that granted the privilege. |
|
|
No |
Yes |
Principal to which the privilege is granted. |
|
|
No |
Yes |
Catalog of relation on which the privilege is granted. |
|
|
No |
Yes |
Schema of relation on which the privilege is granted. |
|
|
No |
Yes |
Relation on which the privilege is granted. |
|
|
No |
Yes |
Privilege being granted. |
|
|
No |
Yes |
Always |
|
|
No |
No |
The ancestor relation that the privilege is inherited from. |
Constraints
The following constraints apply to the TABLE_PRIVILEGES
relation:
Class |
Name |
Column List |
Description |
---|---|---|---|
Primary key |
|
|
Unique identifier for the granted privilege. |
Foreign key |
|
|
References TABLES |