ALTER USER - Kinetica Docs

Any of the following facets of a user can be altered, either individually or as a group:

password
resource group
default schema

ALTER USER Syntax

ALTER USER <user name>
SET
    [ PASSWORD [=] '<user password>' ]
    [ RESOURCE GROUP [=] <group name | DEFAULT> ]
    [ DEFAULT SCHEMA [=] <schema name | DEFAULT> ]
    [ ACTIVATED [=] <TRUE | FALSE> ]

The password needs to be single-quoted and must not contain single quotes.

Examples

To alter a user with the user ID of jsmith, assigning a password of new_secret, and the memory_over_execution resource group:

ALTER USER with Resource Group Example

ALTER USER jsmith
SET
    PASSWORD = 'new_secret'
    RESOURCE GROUP memory_over_execution

To unassign the memory_over_execution resource_group from the jsmith user:

ALTER USER Removing Resource Group Example

ALTER USER jsmith
SET
    RESOURCE GROUP DEFAULT

​Examples

Examples