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. |
Last Article: PG_REPLICATION_SLOTS
Next Article: PG_RULES
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.