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

user_privileges

The user_privileges view displays user permissions on database objects such as tables, views, and schemas. For details, see Table 1. This view is read-only. All users have the read permission on this view. A user can view only the records that the user has the access permission.

Table 1 information_schema.user_privileges columns

Name

Type

Description

GRANTEE

varchar(81)

Name of the user or role to which the permission is granted.

TABLE_CATALOG

varchar(512)

Name of the catalog (database) where the object is located.

PRIVILEGE_TYPE

varchar(64)

Permission granted.

IS_GRANTABLE

varchar(3)
  • yes: The user has the permission to grant permissions.
  • no: The user has no permission to grant permissions.
Parent topic: Information Schemas