Changing a User's Password Using the ALTER USER statement : Password « User Privilege « Oracle PL/SQL Tutorial






SQL>
SQL> --CONNECT system/manager
SQL> CREATE USER user1 IDENTIFIED BY pass1;

User created.

SQL>
SQL> GRANT CREATE SESSION TO user1;

Grant succeeded.

SQL>
SQL> ALTER USER user1 IDENTIFIED BY pass2;

User altered.

SQL>
SQL> DROP USER user1;

User dropped.








36.6.Password
36.6.1.Changing a User's Password Using the ALTER USER statement
36.6.2.Change the password for the current user using the PASSWORD command