• Data Warehouse Service

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

PG_ROLES

PG_ROLES provides access to information about database roles.

Table 1 PG_ROLES columns

Name

Type

Reference

Description

rolname

name

-

Role name

rolsuper

Boolean

-

Whether the role has system administrator permissions

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. Even a system administrator cannot do this unless this column is true.

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

-

User's storage tablespace

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.