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.
Subscribe to:
Post Comments (Atom)
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 ...
-
SAML V2.0 SAML version 2.0 was approved as an OASIS Standard in March 2005. Approved Errata for SAML V2.0 was last produced by the SSTC on 1...
-
Introduction In today's software landscape, designing robust and scalable REST APIs is a crucial aspect of application development. Wit...
-
Spring Boot 3 Spring boot 3 Features : Spring Boot 3.0 will require Java 17 or later Jakarta EE 9 a new top-level jakarta package, replacin...
No comments:
Post a Comment