नोट
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप साइन इन करने या निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
Applies to: 
Databricks SQL Databricks Runtime 10.4 LTS and above Unity Catalog only
INFORMATION_SCHEMA.SCHEMA_PRIVILEGES lists principals that have privileges on a schema in a catalog.
The rows returned are limited to the schemas the user is privileged to interact with.
Definition
The SCHEMA_PRIVILEGES relation contains the following columns:
| Name | Data type | Nullable | Standard | Description |
|---|---|---|---|---|
GRANTOR |
STRING |
No | Yes | Principal that granted the privilege. |
GRANTEE |
STRING |
No | Yes | Principal to which the privilege is granted. |
CATALOG_NAME |
STRING |
No | Yes | Catalog of schema on which the privilege is granted. |
SCHEMA_NAME |
STRING |
No | Yes | Schema on which the privilege is granted. |
PRIVILEGE_TYPE |
STRING |
No | Yes | Privilege being granted. |
IS_GRANTABLE |
STRING |
No | Yes | Always NO. Reserved for future use. |
INHERITED_FROM |
STRING |
Yes | No | The ancestor relation that the privilege is inherited from. |
Constraints
The following constraints apply to the SCHEMA_PRIVILEGES relation:
| Class | Name | Column List | Description |
|---|---|---|---|
| Primary key | SCHEMAPRIVS_PK |
GRANTOR, GRANTEE, CATALOG_NAME, SCHEMA_NAME, PRIVILEGE_TYPE |
Unique identifier for the granted privilege. |
| Foreign key | SCHEMAPRIVS_SCHEMATA_FK |
CATALOG_NAME, SCHEMA_NAME |
References SCHEMATA |
Examples
> SELECT catalog_name, schema_name, grantee
FROM information_schema.schema_privileges;