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	-	Role name
rolsuper	Boolean	-	Whether the role is the initial system administrator with the highest permission
rolinherit	Boolean	-	Whether the role inherits the permissions for this type of roles
rolcreaterole	Boolean	-	Whether the role can create other roles
rolcreatedb	Boolean	-	Whether the role can create databases
rolcatupdate	Boolean	-	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	-	Whether the role can log in to the database
rolreplication	Boolean	-	Whether the role can be replicated
rolauditadmin	Boolean	-	Whether the role is an audit system administrator
rolsystemadmin	Boolean	-	Whether the role is a system administrator
rolconnlimit	integer	-	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	-	Not the password (always reads as ********)
rolvalidbegin	timestamp with time zone	-	Start time of the account validity period (null if no start time)
rolvaliduntil	timestamp with time zone	-	Password expiry time (null if no expiration)
rolrespool	name	-	Resource pool that a user can use
rolparentid	oid	PG_AUTHID.rolparentid	OID of a group user to which the user belongs
roltabspace	text	-	Storage space of the user permanent table
roltempspace	text	-	Storage space of the user temporary table
rolspillspace	text	-	Operator disk flushing space of the user
rolconfig	text[]	-	Session defaults for runtime configuration variables
oid	oid	PG_AUTHID.oid	Role ID
roluseft	Boolean	PG_AUTHID.roluseft	Whether the role can perform operations on foreign tables
rolkind	"char"	-	Role type
nodegroup	name	-	Unsupported currently
rolmonitoradmin	Boolean	-	Whether the role is a monitor administrator
roloperatoradmin	Boolean	-	Whether the role is an O&M administrator
rolpolicyadmin	Boolean	-	Whether the role is a security policy administrator