PG_ROLES

PG_ROLES provides information about database roles. Initialization users and users with the sysadmin or createrole attribute can view information about all roles. Other users can view only their own information.

**Table 1** PG_ROLES columns
Name	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 t (true): yes f (false): no
rolinherit	boolean	N/A	Whether the role inherits the permissions for this type of roles t (true): yes f (false): no
rolcreaterole	boolean	N/A	Whether the role can create other roles t (true): yes f (false): no
rolcreatedb	boolean	N/A	Whether the role can create databases t (true): yes f (false): no
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 unavailable for other users. t (true): yes f (false): no
rolcanlogin	boolean	N/A	Whether the role can log in to the database t (true): yes f (false): no
rolreplication	boolean	N/A	Whether the role can be replicated t (true): yes f (false): no
rolauditadmin	boolean	N/A	Whether the role is an audit system administrator t (true): yes f (false): no
rolsystemadmin	boolean	N/A	Whether the role is a system administrator t (true): yes f (false): no
rolconnlimit	integer	N/A	Sets the maximum number of concurrent connections that this role can initiate if this role can log in. The value –1 indicates no limit.
rolpassword	text	N/A	Not the password (always reads as ********)
rolvalidbegin	timestamp with time zone	N/A	Start time of the account validity period (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	rolparentid in PG_AUTHID	OID of a group user to which the user belongs
roltabspace	text	N/A	Storage space of the user permanent table
rolconfig	text[]	N/A	Session defaults for runtime configuration variables
oid	oid	OID in PG_AUTHID	Role ID
roluseft	boolean	roluseft in PG_AUTHID	Whether the role can perform operations on foreign tables t (true): yes f (false): no
rolkind	"char"	N/A	Role type
nodegroup	name	N/A	Name of the logical cluster associated with the role. (The current feature is a lab feature. Contact Huawei engineers for technical support before using it.) If no logical cluster is associated, this column is left empty.
roltempspace	text	N/A	Storage space of the user temporary table, in KB
rolspillspace	text	N/A	Operator disk spill space of the user, in KB
rolmonitoradmin	boolean	N/A	Whether the role is a monitor administrator t (true): yes f (false): no
roloperatoradmin	boolean	N/A	Whether the role is an O&M administrator t (true): yes f (false): no
rolpolicyadmin	boolean	N/A	Whether the role is a security policy administrator t (true): yes f (false): no