Oracle SQL commands

To create a User in the database

SQL> CRETAE USER <username> IDENTIFIED BY <SID database> DEFAULT TABLESPACE USER_DATA TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK

User created.

SQL> GRANT CONNECT TO <username>

Grant succeeded.

SQL> GRANT SELECT ANY TABLE TO <username>

Grant Succeeded.

SQL> CONNECT <username>/<<SID database>