Lu, Huayi
e6fa411af0
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: Lu, Huayi <luhuayi@huawei.com> Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
14 KiB
PG_SHADOW
PG_SHADOW displays properties of all roles that are marked as rolcanlogin in PG_AUTHID.
This view is not readable to all users because it contains passwords. PG_USER is a publicly readable view on PG_SHADOW that blanks out the password column.
Name |
Type |
Reference |
Description |
|---|---|---|---|
usename |
name |
PG_AUTHID.rolname |
User name |
usesysid |
oid |
PG_AUTHID.oid |
ID of a user |
usecreatedb |
boolean |
- |
Indicates that the user can create databases. |
usesuper |
boolean |
- |
Indicates that the user is an administrator. |
usecatupd |
boolean |
- |
Indicates that the user can update system catalogs. Even the system administrator cannot do this unless this column is true. |
userepl |
boolean |
- |
User can initiate streaming replication and put the system in and out of backup mode. |
passwd |
text |
- |
Password (possibly encrypted); null if none. See PG_AUTHID for details about how encrypted passwords are stored. |
valbegin |
timestamp with time zone |
- |
Account validity start time; null if no start time |
valuntil |
timestamp with time zone |
- |
Password expiry time; null if no expiration |
respool |
name |
- |
Resource pool used by the user |
parent |
oid |
- |
Parent resource pool |
spacelimit |
text |
- |
The storage space of the permanent table. |
tempspacelimit |
text |
- |
The storage space of the temporary table. |
spillspacelimit |
text |
- |
The operator disk flushing space. |
useconfig |
text[ ] |
- |
Session defaults for runtime configuration variables |