Managed Service for Greenplum® API, REST: User.List

Field

Description

clusterId

string

Required field. ID of the Greenplum® cluster.

The maximum string length in characters is 50.

Field

Description

users[]

User

List of cluster users.

Field

Description

name

string

Required field. User name

The string length in characters must be 1-63. Value must match the regular expression ^[a-zA-Z_][a-zA-Z0-9_]{0,62}$.

password

string

User password. Used only in create and update requests

The maximum string length in characters is 128.

login

boolean

Is user allowed to login. Corresponds LOGIN user privilege. Default value: True

resourceGroup

string

Resource group for user's queries

Value must match the regular expression ^([^\|/*?.,;'<>]+|)$.

settings

UserSettingsConfig

DB and Pooler specific settings

Field

Description

poolMode

enum (PoolMode)

Odyssey® route server pool mode.
When POOL_MODE_UNSPECIFIED, uses the cluster-level pool.mode setting.

• SESSION: Assign server connection to a client until it disconnects.
• TRANSACTION: Assign server connection to a client for a transaction processing.

poolSize

string (int64)

Odyssey® server pool size.
The number of servers in the server pool. Clients are placed in a wait queue when all servers are busy.
Set to zero to disable the limit.
If not set, uses the cluster-level pool.size setting.

The minimum value is 0.

poolClientIdleTimeout

string (int64)

Odyssey® client pool idle timeout, in seconds.
Drop stale client connection after this much seconds of idleness, which is not in transaction.
Set to zero to disable.
If not set, uses the cluster-level pool.client_idle_timeout setting.

The minimum value is 0.

poolIdleInTransactionTimeout

string (int64)

Odyssey® client pool idle in transaction timeout, in seconds.
Drop client connection in transaction after this much seconds of idleness.
Set to zero to disable.
If not set, uses the cluster-level pool.idle_in_transaction_timeout setting.

The minimum value is 0.