CATALOG_PRIVILEGES
Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above Unity Catalog only
INFORMATION_SCHEMA.CATALOG_PRIVILEGES lists principals that have privileges on a catalog.
Definition
The CATALOG_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 on which the privilege is granted. |
|
|
No |
Yes |
Privilege being granted. |
|
|
No |
Yes |
Always |
|
|
Yes |
No |
The ancestor relation that the privilege is inherited from. |
Constraints
The following constraints apply to the CATALOG_PRIVILEGES
relation:
Class |
Name |
Column List |
Description |
---|---|---|---|
Primary key |
|
|
Unique identifier for the granted privilege. |
Foreign key |
|
|
References CATALOGS |