Oracle user creation

Create user <name>identified by <passwd> default tablespace <tablespacename> temporary tablespace <temp>;


grant <sysdba> to <username>;

Altering User

SQL> -- with SQL*Plus
SQL> alter user scott identified by ***;

User altered.
SQL> -- with PL/SQL
SQL> begin
2 execute immediate 'alter user scott identified by tiger';
3 end;
4 /PL/SQL procedure successfully completed.
SQL>