Wednesday, March 13, 2019

Create new Database from command line Oracle 11g Express


I share example how to create new user from command line, you need SQL*Plus or JDeveloper and super user, I'm using Oracle 11g Express for that use the user SYSTEM.

Steps:

Step 1:

connect SYSTEM/password; 

Step 2:

CREATE USER your_schema IDENTIFIED BY your_password; 

Step 3:

ALTER USER your_schema QUOTA UNLIMITED ON SYSTEM; 

Step 4:

GRANT CREATE SESSION, CONNECT, RESOURCE, DBA TO your_schema; 

Step 5:

GRANT ALL PRIVILEGES TO your_schema; 

You try connect with the new user.

That's it. 

No comments:

Post a Comment

Virtual Threads in Java 21: Simplified Concurrency for Modern Applications

  With Java 21, Virtual Threads have redefined how we approach concurrency, offering a lightweight and efficient way to handle parallel and ...