PG_ROLES

PG_ROLES displays information about database roles.

**Table 1** PG_ROLES columns
Column	Type	Reference	Description
rolname	Name	N/A	Role name
rolsuper	boolean	N/A	Whether the role is the initial system administrator with the highest permission
rolinherit	boolean	N/A	Whether the role inherits permissions for this type of roles
rolcreaterole	boolean	N/A	Whether the role can create other roles
rolcreatedb	boolean	N/A	Whether the role can create databases
rolcatupdate	boolean	N/A	Whether the role can update system tables directly. Only the initial system administrator whose usesysid is 10 has this permission. It is not available for other users.
rolcanlogin	boolean	N/A	Whether the role can log in to the database
rolreplication	boolean	N/A	Whether the role can be replicated
rolauditadmin	boolean	N/A	Whether the role is an audit system administrator
rolsystemadmin	boolean	N/A	Whether the role is a system administrator
rolconnlimit	Integer	N/A	Limits the maximum number of concurrent connections of a user on a CN. -1 indicates no limit.
rolpassword	Text	N/A	Not the password (always reads as ********)
rolvalidbegin	Timestamp with time zone	N/A	Account validity start time; null if no start time
rolvaliduntil	Timestamp with time zone	N/A	Password expiry time; null if no expiration
rolrespool	Name	N/A	Resource pool that a user can use
rolparentid	OID	PG_AUTHID.rolparentid	OID of a group user to which the user belongs
roltabspace	Text	N/A	The storage space of the user permanent table.
roltempspace	Text	N/A	The storage space of the user temporary table.
rolspillspace	Text	N/A	The operator disk flushing space of the user.
rolconfig	Text[]	N/A	Session defaults for runtime configuration variables
OID	OID	PG_AUTHID.oid	ID of the role
roluseft	boolean	PG_AUTHID.roluseft	Whether the role can perform operations on foreign tables
nodegroup	Name	N/A	Name of the logical cluster associated with the role. If no logical cluster is associated, this column is left empty.