ROUTINE_PRIVILEGES
Preview
This feature is in Public Preview.
Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above Unity Catalog only
INFORMATION_SCHEMA.ROUTINE_PRIVILEGES lists principals that have privileges on a routine in a catalog.
The rows returned are limited to the routines the user is privileged to interact with.
Definition
The ROUTINE_PRIVILEGES
relation contains the following columns:
Name |
Data type |
Nullable |
Standard |
Description |
---|---|---|---|---|
|
|
No |
Yes |
Principal who granted the privilege. |
|
|
No |
Yes |
Principal to which the privilege is granted. |
|
|
No |
Yes |
Catalog of routine on which the privilege is granted. |
|
|
No |
Yes |
Database of routine on which the privilege is granted. |
|
|
No |
Yes |
Schema unique (specific) name of routine on which the privilege is granted. |
|
|
No |
Yes |
Matches |
|
|
No |
Yes |
Matches |
|
|
No |
Yes |
Name of routine 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 ROUTINE_PRIVILEGES
relation:
Class |
Name |
Column List |
Description |
---|---|---|---|
Primary key |
|
|
Unique identifier for the granted privilege. |
Foreign key |
|
|
References ROUTINES |