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

1. Oracle PL/SQL Tutorial
2. User Privilege
3. Password

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.