Updated on 2024-09-02 GMT+08:00

PG_ROLES

PG_ROLES displays information about database roles.

Table 1 PG_ROLES columns

Name

Type

Reference

Description

rolname

name

N/A

Role name

rolsuper

boolean

N/A

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

rolinherit

boolean

N/A

Whether the role inherits permissions for this type of roles

rolcreaterole

boolean

N/A

Whether the role can create other roles

rolcreatedb

boolean

N/A

Whether the role can create databases

rolcatupdate

boolean

N/A

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

N/A

Whether the role can log in to the database

rolreplication

boolean

N/A

Whether the role can be replicated

rolauditadmin

boolean

N/A

Whether the role is an audit system administrator

rolsystemadmin

boolean

N/A

Whether the role is a system administrator

rolconnlimit

integer

N/A

Limits the maximum number of concurrent connections of a user on a CN. -1 indicates no limit.

rolpassword

text

N/A

Not the password (always reads as ********)

rolvalidbegin

timestamp with time zone

N/A

Account validity start time; null if no start time

rolvaliduntil

timestamp with time zone

N/A

Password expiry time; null if no expiration

rolrespool

name

N/A

Resource pool that a user can use

rolparentid

oid

PG_AUTHID.rolparentid

OID of a group user to which the user belongs

roltabspace

text

N/A

The storage space of the user permanent table.

roltempspace

text

N/A

The storage space of the user temporary table.

rolspillspace

text

N/A

The operator disk flushing space of the user.

rolconfig

text[]

N/A

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

N/A

Name of the logical cluster associated with the role. If no logical cluster is associated, this column is left empty.