information_schema.SCHEMA_PRIVILEGES

2025-12-09 07:09:36  Updated

Feature

This view provides information about database privileges.

Fields

Field Type Nullable Description
GRANTEE varchar(81) NO The username of the user to which the privilege is granted.
TABLE_CATALOG varchar(4096) NO The name of the catalog to which the table belongs. The value of this field is always def.
TABLE_SCHEMA varchar(128) NO The name of the database.
PRIVILEGE_TYPE varchar(64) NO The type of the privilege.
IS_GRANTABLE varchar(3) NO Indicates whether the user has the GRANT OPTION privilege.

Contact Us