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)
Provisioning Cloud SQL with Private Service Connect Using Terraform & Accessing from Cloud Run with Spring Boot
In this post, we'll explore how to provision Cloud SQL instances with Private Service Connect (PSC) connectivity using Terraform and the...
-
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...
-
Single Sign-On (SSO) is an authentication process that allows users to access multiple applications or services with a single set of login c...
-
Introduction: Sometimes we need to interact with Spring Boot GraphQL API and Spring Boot Rest API in the same time, in this case we can use ...
No comments:
Post a Comment