> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ALTER USER

<a id="sql-security-user-mgmt-alter" />

Any of the following facets of a [user](/content/security/sec_concepts#security-concepts-users) can be
altered, either individually or as a group:

* password
* [resource group](/content/rm/concepts#rm-concepts-resource-groups)
* [default schema](/content/concepts/schemas#schema-default)

```sql title="ALTER USER Syntax" theme={null}
ALTER USER <user name>
SET
    [ PASSWORD [=] '<user password>' ]
    [ RESOURCE GROUP [=] <group name | DEFAULT> ]
    [ DEFAULT SCHEMA [=] <schema name | DEFAULT> ]
    [ ACTIVATED [=] <TRUE | FALSE> ]
```

<Info>
  The password needs to be single-quoted and must not contain single quotes.
</Info>

## Examples

To alter a user with the user ID of **jsmith**, assigning a
password of **new\_secret**, and the **memory\_over\_execution** *resource group*:

```sql ALTER USER with Resource Group Example theme={null}
ALTER USER jsmith
SET
    PASSWORD = 'new_secret'
    RESOURCE GROUP memory_over_execution
```

To unassign the **memory\_over\_execution** *resource\_group* from the **jsmith**
user:

```sql ALTER USER Removing Resource Group Example theme={null}
ALTER USER jsmith
SET
    RESOURCE GROUP DEFAULT
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.