PG_SHADOW

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

The name stems from the fact that this view 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

Username

usesysid

oid

PG_AUTHID.oid

ID of this user

usecreatedb

Boolean

-

Indicates that the user can create databases.

usesuper

Boolean

-

Indicates that the user is an administrator.

usecatupd

Boolean

-

Users can update a view. 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 period 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 of the permanent table

tempspacelimit

text

-

Storage space of the temporary table

spillspacelimit

text

-

Operator disk flushing space

useconfig

text[ ]

-

Session defaults for runtime configuration variables

usemonitoradmin

Boolean

-

Whether the user is a monitor administrator

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

useoperatoradmin

Boolean

-

Whether the user is an O&M administrator

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

usepolicyadmin

Boolean

-

Whether the user is a security policy administrator

  • t (true): yes.
  • f (false): no.
Feedback
编组 3备份
    openGauss 2024-07-13 01:01:39
    cancel