Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ System Catalogs and System Views/ System Views/ User and Permission Management/ ADM_ROLES
Updated on 2025-08-19 GMT+08:00
View PDF

ADM_ROLES

ADM_ROLES displays information about database roles. This view exists in both the PG_CATALOG and SYS schemas. By default, only the system administrator can access this view.

Table 1 ADM_ROLES columns

Name

Type

Description

role

character varying(128)

Role name.

role_id

oid

Role ID.

authentication_type

text

Role authentication mechanism.

  • password: Password authentication is required.
  • NULL: Authentication is not required.

common

character varying(3)

Not supported. Its value is NULL.

oracle_maintained

character varying(1)

Not supported. Its value is NULL.

inherited

character varying(3)

Not supported. Its value is NULL.

implicit

character varying(3)

Not supported. Its value is NULL.

external_name

character varying(4000)

Not supported. Its value is NULL.