Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ System Catalogs and System Views/ System Views/ PG_SHADOW
Updated on 2025-08-19 GMT+08:00
View PDF

PG_SHADOW

PG_SHADOW displays the attributes of all roles marked with rolcanlogin in PG_AUTHID. Only users with the SYSADMIN permission can access this system view.

The information in this view is basically the same as that of the view in PG_USER. The difference is that passwords are sensitive and displayed as ******** in the latter.

Table 1 PG_SHADOW columns

Name

Type

Reference

Description

usename

name

rolname in PG_AUTHID

Username.

usesysid

oid

oid in PG_AUTHID

ID of this user.

usecreatedb

Boolean

-

Specifies whether a user has the permissions to create databases.

  • t (true): yes.
  • f (false): no.

usesuper

Boolean

-

Specifies whether the user is a SYSADMIN.

  • t (true): yes.
  • f (false): no.

usecatupd

Boolean

-

Specifies whether the user can update a view. Even the SYSADMIN cannot update the view unless this column is t.

  • t (true): yes.
  • f (false): no.

userepl

Boolean

-

Specifies whether the user has the permissions to duplicate data streams.

  • t (true): yes.
  • f (false): no.

passwd

text

rolpassword in PG_AUTHID

Password ciphertext. If there is no password, the value is NULL.

valbegin

timestamp with time zone

-

Start time for account validity (NULL if start time is not specified).

valuntil

timestamp with time zone

-

End time for account validity (NULL if end time is not specified).

respool

name

-

Resource pool where the user is in.

parent

oid

-

Parent user OID.

spacelimit

text

-

Storage space of the permanent table, in KB.

useconfig

text[]

setconfig in PG_DB_ROLE_SETTING

Default value of runtime configuration items.

tempspacelimit

text

-

Storage space of the temporary table, in KB.

spillspacelimit

text

-

Operator disk flushing space, in KB.

usemonitoradmin

Boolean

-

Specifies whether the user has the MONADMIN permission.

  • t (true): yes.
  • f (false): no.

useoperatoradmin

Boolean

-

Specifies whether the user has OPRADMIN permission.

  • t (true): yes.
  • f (false): no.

usepolicyadmin

Boolean

-

Specifies whether the user has the POLADMIN permission.

  • t (true): yes.
  • f (false): no.
Parent topic: System Views