• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_SHADOW

PG_SHADOW

PG_SHADOW shows properties of all roles that are marked as rolcanlogin in PG_AUTHID.

The name stems from the fact that this table should not be readable by the public since it contains passwords. PG_USER is a publicly readable view on PG_SHADOW that blanks out the password column.

Table 1 PG_SHADOW columns

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

-

Storage space upper limit

useconfig

text[ ]

-

Session defaults for runtime configuration variables