ADM_ROLES

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

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.