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 |