Help Center > > Developer Guide> System Catalogs and System Views> System Views> PG_ROLES

PG_ROLES

Updated at: Jul 15, 2020 GMT+08:00

PG_ROLES displays information about database roles.

Table 1 PG_ROLES columns

Name

Type

Reference

Description

rolname

name

-

Role name

rolsuper

Boolean

-

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

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. Only the initial system administrator whose usesysid is 10 has this permission. It is not available for other users.

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

-

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.

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel