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
|
-
|
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
|
-
|
Storage space of the user permanent table
|
roltempspace
|
text
|
-
|
Storage space of the user temporary table, in KB
|
rolspillspace
|
text
|
-
|
Operator disk spill space of the user, in KB
|
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
|
rolmonitoradmin
|
Boolean
|
-
|
Whether the role is a monitor administrator
|
roloperatoradmin
|
Boolean
|
-
|
Whether the role is an O&M administrator
|
rolpolicyadmin
|
Boolean
|
-
|
Whether the role is a security policy administrator
|