PG_ROLES¶
PG_ROLES displays information about database roles.
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 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 not available 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 this role can make if this role can log in. -1 indicates no limit. |
rolpassword | text |
| Not the password (always reads as |
rolvalidbegin | timestamp with time zone |
| Account validity start time; 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 |
| The storage space of the user permanent table. |
roltempspace | text |
| The storage space of the user temporary table. |
rolspillspace | text |
| The operator disk flushing space of the user. |
rolconfig | text[] |
| 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 |
| Name of the logical cluster associated with the role. If no logical cluster is associated, this column is left empty. |