PG_USER

usename

name

Username

usesysid

oid

ID of this user

usecreatedb

boolean

Whether the user has the permissions to create databases

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

usesuper

boolean

whether the user is the initial system administrator with the highest rights

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

usecatupd

boolean

whether the user can directly update system tables. Only the initial system administrator whose usesysid is 10 has this permission. It is unavailable for other users.

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

userepl

boolean

Whether the user has the permissions to duplicate data streams

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

passwd

text

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

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

useconfig

text[]

Session defaults for runtime configuration variables

nodegroup

name

Name of the logical (The current feature is a lab feature. Contact Huawei technical support before using it.) associated with the user. If no logical cluster is associated, this column is left blank.

tempspacelimit

text

Storage space of the temporary table

spillspacelimit

text

Operator disk flushing space

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.