• Data Warehouse Service

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

PG_USER

PG_USER stores information about users who can access the database.

Table 1 PG_USER columns

Name

Type

Description

usename

name

User name.

usesysid

oid

ID of this user

usecreatedb

Boolean

Whether the user has the permission to create databases

usesuper

Boolean

Whether the user is a system administrator

usecatupd

Boolean

Whether the user has the permission to update system catalogs Even a system administrator does not have this permission unless this column is true.

userepl

Boolean

Whether the user has the permission to duplicate data streams

passwd

text

Encrypted user password. The value is displayed as ********.

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 where the user is in

parentid

oid

Parent user OID

spacelimit

text

Storage space upper limit

useconfig

text[]

Session defaults for run-time configuration variables

nodegroup

name

Name of the logical cluster associated with the user. If no logical cluster is associated, this column is left blank.