Mega Code Archive

 

Categories / Oracle PLSQL / User Previliege

 

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>