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

ADM_ROLES

ADM_ROLES displays information about database roles. This view is accessible only to system administrators. This view exists in both PG_CATALOG and SYS schemas.

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.
Parent topic: System Views