schema_privileges
Overviewβ
View the authorization information of the database.
Databaseβ
information_schema
Table Informationβ
| Column Name | Type | Description |
|---|---|---|
| GRANTEE | varchar(81) | The authorized user |
| TABLE_CATALOG | varchar(512) | The Catalog name, always 'def' |
| TABLE_SCHEMA | varchar(64) | The Database name |
| PRIVILEGE_TYPE | varchar(64) | The type of privilege |
| IS_GRANTABLE | varchar(3) | Whether authorization can be granted to other users |
