51.82. pg_roles
The view
pg_roles
provides access to
information about database roles. This is simply a publicly
readable view of
pg_authid
that blanks out the password field.
Table 51.83.
pg_roles
Columns
| Name | Type | References | Description |
|---|---|---|---|
rolname
|
name
|
Role name | |
rolsuper
|
bool
|
Role has superuser privileges | |
rolinherit
|
bool
|
Role automatically inherits privileges of roles it is a member of | |
rolcreaterole
|
bool
|
Role can create more roles | |
rolcreatedb
|
bool
|
Role can create databases | |
rolcanlogin
|
bool
|
Role can log in. That is, this role can be given as the initial session authorization identifier | |
rolreplication
|
bool
|
Role is a replication role. A replication role can initiate replication connections and create and drop replication slots. | |
rolconnlimit
|
int4
|
For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means no limit. | |
rolpassword
|
text
|
Not the password (always reads as
********
)
|
|
rolvaliduntil
|
timestamptz
|
Password expiry time (only used for password authentication); null if no expiration | |
rolbypassrls
|
bool
|
Role bypasses every row level security policy, see Section 5.8 for more information. | |
rolconfig
|
text[]
|
Role-specific defaults for run-time configuration variables | |
oid
|
oid
|
|
ID of role |