54.20. pg

54.20. `pg_roles`
Prev	Up	Chapter 54. System Views	Home	Next

54.20. `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 54.20. pg_roles Columns

+ Column Type + + + 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` + (references `pg_authid`.`oid`) + + + ID of role +

+ Column Type +

+ 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 + (references pg_authid.oid) +

+ ID of role +

Prev	Up	Next
54.19. `pg_replication_slots`	Home	54.21. `pg_rules`

54.20. pg_roles

54.20. `pg_roles`