Alter user to change password : Alter User « User Previliege « Oracle PL / SQL

1. Oracle PL / SQL
2. User Previliege
3. Alter User

Alter user to change password

 
SQL>
SQL> CREATE USER newUserName IDENTIFIED BY password;

User created.

SQL>
SQL> SELECT default_tablespace, temporary_tablespace
  2  FROM dba_users
  3  WHERE username='NEWUSERNAME';

DEFAULT_TABLESPACE             TEMPORARY_TABLESPACE
------------------------------ ------------------------------
SYSTEM                         TEMP

SQL>
SQL> ALTER USER newUserName IDENTIFIED BY newPass;

User altered.

SQL>
SQL> DROP USER newUserName;

User dropped.

SQL>

 

Related examples in the same category