Altering database users

You can use the ALTER USER command to change the name, password, expiration, owner, and session settings of an existing database user account.

You can also unlock an account if it was configured to lock after a specified number of failed login attempts. To change the account, log in to the database by using an account that has Alter administrative privilege. For example, the following command assigns a user to the group named silver:

SYSTEM.ADMIN(ADMIN)=> ALTER USER dlee WITH IN RESOURCEGROUP silver;
ALTER USER