• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_AUTHID

PG_AUTHID

PG_AUTHID contains information about database authorization identifiers (roles).

Table 1 PG_AUTHID columns

Name

Type

Description

oid

oid

Column identifier (hidden attribute; must be specified)

rolname

name

Role name

rolsuper

Boolean

Whether the role has system administrator permissions

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 tables. If this column is not set to true, even a system administrator cannot update system tables.

rolcanlogin

Boolean

Whether the role can log in. That is, 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

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). The value is 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

User's storage space limit

rolnodegroup

oid

OID of a Node Group associated with a user. The Node Group must be a logical cluster.