Updated on 2024-05-07 GMT+08:00

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 schema.

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.