Name of the new user. Names that contain special characters must be double-quoted. To enforce case-sensitivity, use double-quotes.

For details on name requirements, see Creating a Database Name and Password.

Locks or unlocks user access to the database, set to one of the following:

• UNLOCK (default) 
• LOCK prevents a new user from logging in. This can be useful when creating an account for a user who does not need immediate access.

Specifies how long a user query can block on any session socket, set to one of the following:

• NONE (default): Removes any grace period previously set on session queries.
• 'interval': Specifies as an interval the maximum grace period for current session queries, up to 20 days.

For details, see Handling Session Socket Blocking.

Sets the new user's password, where password must conform to the password complexity policy set by the user's profile.

If you supply an empty string or omit this parameter, the user is assigned no password and is not prompted for one when connecting.

For details, see Password Guidelines and Creating a Database Name and Password.

The length of time the system waits before disconnecting an idle session, set to one of the following:

• NONE (default): No limit set for this user. If you omit this parameter, no limit is set for this user.
• 'interval' An interval value, up to one year.

For details, see Managing Client Connections.

Specifies the maximum number of connections the user can have to the server, set to one of the following:

• NONE (default): No limit set. If you omit this parameter, the user can have an unlimited number of connections across the database cluster.

• integer [connection‑mode]: Specifies the maximum number of connections allowed to the user, where connection‑mode is one of the following:

  • ON DATABASE (default): Allows up to integer connections across the database cluster.
  • ON NODE: Allows up to integer connections to each node.

For details, see Managing Client Connections.

Specifies how much memory can be allocated to user requests, set to one of the following:

• NONE (default): No limit

• A string value that specifies the memory limit, one of the following:

  • int% — Expresses the maximum as a percentage of total memory available to the Resource Manager, where int is an integer value between 0 and 100.For example:

    MEMORYCAP '40%'

  • int{K|M|G|T} — Expresses memory allocation in kilobytes, megabytes, gigabytes, or terabytes. For example:

    MEMORYCAP '10G'

Forces immediate expiration of the user's password. The user must change the password on the next login.

Assigns a profile that controls password requirements for this user, set to one of the following:

• DEFAULT (default): Assigns the default database profile to this user.
• profile-name: A profile that is defined by CREATE PROFILE. If you omit this parameter, the user is assigned the default profile.

Assigns a default resource pool to this user. The user must also be granted privileges to this pool, unless privileges to the pool are set to PUBLIC.

Specifies how long this user's queries can execute, set to one of the following:

• NONE (default): No limit set for this user. If you omit this parameter, no limit is set for this user.
• 'interval' An interval value, up to one year.

A query's runtime limit can be set at three levels: the user's runtime limit, the user's resource pool, and the session setting. For more information, see Setting a Runtime Limit for Queries in the Administrator's Guide.

Specifies the user's default search path that tells Vertica which schemas to search for unqualified references to tables and UDFs, set to one of the following:

• DEFAULT (default): Sets the search path as follows:

  "$user", public, v_catalog, v_monitor, v_internal

• Comma-delimited list of schemas.

For details, see Setting Search Paths in the Administrator's Guide.

Limits how much temporary file storage is available for user requests, set to one of the following:

• NONE (default): No limit

• A string value that specifies the memory limit, one of the following:

  • int% — Expresses the maximum as a percentage of total memory available to the Resource Manager, where int is an integer value between 0 and 100.For example:

    MEMORYCAP '40%'

  • int{K|M|G|T} — Expresses memory allocation in kilobytes, megabytes, gigabytes, or terabytes. For example:

    TEMPSPACECAP '10G'