PG_AUTHID

PG_AUTHID records information about 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 its rolcanlogin is set or not, can use other roles as members.

For openGauss, only one PG_AUTHID exists, which is not available for every database. This system catalog is accessible only to system administrators.

Table 1 PG_AUTHID columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified)

rolname

name

Specifies the name of a role.

rolsuper

Boolean

Whether the role is the initial system administrator with the highest permission

rolinherit

Boolean

Whether the role automatically inherits permissions of roles of which it is a member

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 unavailable for other users.

rolcanlogin

Boolean

Whether the role can log in (whether this 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

Username of the administrator

rolconnlimit

integer

Maximum number of concurrent connections that this role can make (valid for roles that can log in)

The value -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 the role can perform operations on foreign tables

rolparentid

oid

OID of a group user to which the user belongs

roltabspace

text

Maximum size of a user data table

rolkind

char

Special user types, including private users and common users

rolnodegroup

oid

Unsupported currently

roltempspace

text

Storage space of the user temporary table

rolspillspace

text

Maximum size of data that can be written to disks when a user executes a job

rolexcpdata

text

Query rules that can be set by users (reserved)

Feedback
编组 3备份
    openGauss 2024-05-26 00:42:43
    cancel