Who Can Alter A User?

Who Can Alter a User?

To modify the account of another user, the current user must have

administrator privileges in the security database
the USER_MANAGEMENT system privilege in the security databaseUsers with the USER_MANAGEMENT system privilege can not grant or revoke the admin role.

Anyone can modify their own account, except for the GRANT/REVOKE ADMIN ROLE and ACTIVE/INACTIVE options, which require administrative privileges to change.

`ALTER USER` Examples

Changing the password for the user bobby and granting them user management privileges:
```
ALTER USER bobby PASSWORD '67-UiT_G8'
GRANT ADMIN ROLE;
```
Editing the optional properties (the first and last names) of the user dan:
```
ALTER USER dan
FIRSTNAME 'No_Jack'
LASTNAME 'Kennedy';
```
Revoking user management privileges from user dumbbell:
```
ALTER USER dumbbell
DROP ADMIN ROLE;
```

Who Can Alter A User?

Who Can Alter a User?

ALTER USER Examples

`ALTER USER` Examples