PG_ROLES

rolname

name

-

Role name

rolsuper

Boolean

-

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

rolinherit

Boolean

-

Whether the role inherits the 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 unavailable 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 that this role can initiate if this role can log in. The value -1 indicates no limit.

rolpassword

text

-

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

rolvalidbegin

timestamp with time zone

-

Start time of the account validity period (null if no start time)

rolvaliduntil

timestamp with time zone

-

End time for account validity (null if no end time)

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

-

Storage space of the user permanent table

roltempspace

text

-

Storage space of the user temporary table

rolspillspace

text

-

Operator disk spill space of the user

rolconfig

text[]

-

Session defaults for runtime configuration variables

oid

oid

PG_AUTHID.oid

Role ID

roluseft

Boolean

PG_AUTHID.roluseft

Whether the role can perform operations on foreign tables

rolkind

"char"

-

Role type

nodegroup

name

-

Unsupported currently