Help Center/ GaussDB/ M-Compatibility Developer Guide(Centralized)/ Schemas/ Information Schemas/ table_privileges
Updated on 2025-10-23 GMT+08:00
View PDF
Share

table_privileges

The table_privileges view provides information about table permissions. This view is read-only. All users have the read permission on this view.

Table 1 information_schema.table_privileges columns

Name

Type

Description

GRANTEE

varchar(81)

Name of the account to which the permission is granted.

TABLE_CATALOG

varchar(512)

Name of the catalog to which the table belongs.

TABLE_SCHEMA

varchar(64)

Name of the schema to which the table belongs.

TABLE_NAME

varchar(64)

Name of the table.

PRIVILEGE_TYPE

varchar(64)

Permission granted. The value is any permission that can be granted at the table level.

IS_GRANTABLE

varchar(3)

If the user has the GRANT OPTION permission, the value is yes; otherwise, the value is no.
Parent topic: Information Schemas