PG_AUTHID
PG_AUTHID records information about the database authentication identifiers (roles). The concept of users is contained in that of roles. A user is actually a role whose rolcanlogin has been set. Any role, whether the rolcanlogin is set or not, can use other roles as members.
For a cluster, only one pg_authid exists which is not available for every database. It is accessible only to users with system administrator rights.
| Name | Type | Description |
|---|---|---|
| oid | oid | Row identifier (hidden attribute; must be explicitly selected) |
| rolname | name | Role name |
| rolsuper | Boolean | Whether the role is the initial system administrator with the highest permission |
| rolinherit | Boolean | Whether the role automatically inherits permissions of roles it is a member of |
| rolcreaterole | Boolean | Whether the role can create more roles |
| rolcreatedb | Boolean | Whether the role can create databases |
| rolcatupdate | Boolean | Whether the role can directly update system catalogs. Only the initial system administrator whose usesysid is 10 has this permission. It is not available for other users. |
| rolcanlogin | Boolean | Whether a role can log in, that is, whether a role can be given as the initial session authorization identifier. |
| rolreplication | Boolean | Indicates that the role is a replicated one (an adaptation syntax and no actual meaning). |
| rolauditadmin | Boolean | Indicates that the role is an audit user. |
| rolsystemadmin | Boolean | Indicates that the role is an administrator. |
| rolconnlimit | integer | For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means no limit. |
| rolpassword | text | Password (possibly encrypted); NULL if no password. |
| 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 |
| roluseft | Boolean | Whether a role can perform operations on foreign tables |
| rolparentid | oid | OID of a group user to which the user belongs |
| rolkind | char | Special type of user, including private users, logical cluster administrators, and common users. |
| rolspacelimit | 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. |
| rolnodegroup | oid | OID of a Node Group associated with a user. The Node Group must be a logical cluster. |
Last Article: PG_ATTRIBUTE
Next Article: PG_AUTH_HISTORY
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.