Oracle PL/SQL/User Previliege/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>

Alter user to grant new quota value

 

alter user hr_audit
    quota unlimited on users
    quota 10M on temp
    quota 0M on system
    /

Create a user, grant permission and alter its password

 
create user hr_audit identified by hr_audit;
grant create session, resource to hr_audit;
alter user hr_audit identified by oracle;