SET USER PASSWORD statement (UNIX, Linux)
Use the SET USER PASSWORD statement to change your password for database server access if you are an internally authenticated user. This statement is an extension to the ANSI/ISO standard for the SQL language.
Syntax
>>-SET USER PASSWORD OLD--old_password--NEW--new_password------><
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| new_password | New password for internal authentication of the user. | Length must be between 6 and 32 bytes. | Quoted String |
| old_password | Existing password for internal authentication of the user. | Length must be between 6 and 32 bytes. | Quoted String |
Usage
A DBSA cannot use this statement to change the password of another user. To change the passwords of other users, a DBSA can use the ALTER USER statement.
Execution of the SET USER PASSWORD statement can be audited with the PWUR audit code.
Example
The following statement changes the password from joebar to joefoo:
SET USER PASSWORD OLD 'joebar' NEW 'joefoo';