Purpose

The ALTER USER command changes the attributes of a user role.

Syntax

ALTER USER user1 attribute_name1 = attribute_value1      \
[, attribute_name2 = attribute_value2, ...]

Usage Notes

• The user name cannot be root, celladmin or cellmonitor. Those are reserved.

• The user name should be unique.

• The system prompts for a password for the new user. The password must have 12 to 40 alphanumeric characters or special characters !@#$%^&*() with at least one digit, one lowercase letter, and one uppercase letter. Starting with Oracle Exadata System Software release 18.1.0.0.0, the password can be 8 to 40 characters in length and can also utilize the special characters - and _.

• The new password cannot be the same as the current password for the user.