Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / User Privilege

 

Changing a Users Password Using the ALTER USER statement

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.