The Oracle SQL Create User/Grant Command - Oracle

Third Command: CREATE USER/GRANT COMMAND

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”.