Oracle is one of the top relational databases in the world and has been used by Fortune 500 companies such as Exxon Mobil, Wal-mart, General Electric and many others. In this tutorial, we will show you six "must know" Oracle SQL commands.
It's not recommended to use SYSTEM user during your actual work (like creating tables, doing queries, etc) within the Oracle database. For that, you should create a new admin user. To do this, you need to use the CREATE USER and GRANT command:
1.) Suppose you want to create a new Oracle database administrator named “new_admin” with a password “adminpassword”. In the SQL*plus command line, issue the CREATE USER command in the SQL prompt:
SQL> CREATE USER new_admin IDENTIFIED BY adminpassword DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;
Then press the Enter key.
2.) To grant database administrator privileges to “new_admin”, you need to use the grant command:
SQL> GRANT connect, resource, dba to new_admin;
If this command is successful you will then see, “Grant succeeded”.