start with oracle - how to create a new user in oracle
sqlplus
Create user ABC identified by ADMIN123; (For others; like 10g)
Or
Create user C##ABC identified by ADMIN123; (For 11g)
Grant dba to ABC; (For others; like 10g)
Or
Grant dba to C##ABC; (For 11g)
#With our new books_admin account created,
#we can now begin adding privileges to the account using the GRANT statement.
#GRANT is a very powerful statement with many possible options,
#but the core functionality is to manage the privileges of both users and roles throughout the database.
Commit;