PG_ROLES¶
PG_ROLES displays information about database roles.
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. |