PG_ROLES

PG_ROLES displays 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	Specifies whether a role is the initial system administrator with the highest permissions.
rolinherit	boolean	N/A	Specifies whether the role inherits the permissions for this type of roles.
rolcreaterole	boolean	N/A	Specifies whether the role can create other roles.
rolcreatedb	boolean	N/A	Specifies whether the role can create databases.
rolcatupdate	boolean	N/A	Specifies 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.
rolcanlogin	boolean	N/A	Specifies whether the role can log in to the database.
rolreplication	boolean	N/A	Specifies whether the role can be replicated.
rolauditadmin	boolean	N/A	Specifies whether the role is an audit administrator.
rolsystemadmin	boolean	N/A	Specifies whether the role is a system administrator.
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	Encrypted user password. The value is displayed as ********.
rolvalidbegin	timestamp with time zone	N/A	Start time for account validity (NULL if no start time).
rolvaliduntil	timestamp with time zone	N/A	End time for account validity (NULL if end time is not specified).
rolrespool	name	N/A	Resource pool that can be used by a user.
rolparentid	oid	PG_AUTHID.rolparentid	OID of a group user to which the user belongs
roltabspace	text	N/A	Storage space limit of the user permanent table, in KB.
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.
rolconfig	text[]	PG_DB_ROLE_SETTING.setconfig	Default value of runtime configuration items.
oid	oid	oid in PG_AUTHID	Role ID
roluseft	boolean	PG_AUTHID.roluseft	Specifies whether the role can perform operations on foreign tables
rolkind	"char"	N/A	Role type n: common user, that is, non-permanent user p: permanent user.
nodegroup	name	N/A	Unsupported currently.
rolmonitoradmin	boolean	N/A	Specifies whether the role is a monitor administrator.
roloperatoradmin	boolean	N/A	Specifies whether the role is an O&M administrator.
rolpolicyadmin	boolean	N/A	Specifies whether the role is a security policy administrator.