README.md

Pre-requisites

• Docker and Docker compose
• Docker Desktop (Optional but recommended)

Installation

1. Clone the repo

    git clone https://github.com/root-hunter/oracle-db.git

2. Move to directory

   cd oracle-db

3. Start container deamon

   docker compose up -d

Connection

We use Sql Developer.

1. Access to database (default pass: password123)

2. Add DBA

Troubleshooting

1. In oracle db image for default is set COMMON_USER_PREFIX with "C##" so every user and role must be start with "C##" prefix, if you want remove this limitation can set COMMON_USER_PREFIX to NULL

SELECT * FROM V$PARAMETER WHERE NAME = 'COMMON_USER_PREFIX';

2. Create a example user with some privileges

-- USER SQL
CREATE USER "C##YELLOWCOM" IDENTIFIED BY "password"  
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP";

-- QUOTAS
ALTER USER "C##YELLOWCOM" QUOTA UNLIMITED ON "USERS";

-- ROLES
GRANT "CONNECT" TO "C##YELLOWCOM" ;

-- SYSTEM PRIVILEGES
GRANT DROP ANY TRIGGER TO "C##YELLOWCOM" ;
GRANT ALTER ANY INDEX TO "C##YELLOWCOM" ;
GRANT DROP ANY SEQUENCE TO "C##YELLOWCOM" ;
GRANT CREATE TRIGGER TO "C##YELLOWCOM" ;
GRANT ALTER ANY PROCEDURE TO "C##YELLOWCOM" ;
GRANT CREATE ANY PROCEDURE TO "C##YELLOWCOM" ;
GRANT CREATE ANY INDEX TO "C##YELLOWCOM" ;
GRANT CREATE OPERATOR TO "C##YELLOWCOM" ;
GRANT CREATE ANY SEQUENCE TO "C##YELLOWCOM" ;
GRANT CREATE VIEW TO "C##YELLOWCOM" ;
GRANT ALTER ANY TABLE TO "C##YELLOWCOM" ;
GRANT SELECT ANY TABLE TO "C##YELLOWCOM" ;
GRANT ALTER ANY SEQUENCE TO "C##YELLOWCOM" ;
GRANT CREATE TABLE TO "C##YELLOWCOM" ;
GRANT DROP ANY TABLE TO "C##YELLOWCOM" ;
GRANT DROP ANY OPERATOR TO "C##YELLOWCOM" ;
GRANT CREATE ANY OPERATOR TO "C##YELLOWCOM" ;
GRANT CREATE TYPE TO "C##YELLOWCOM" ;
GRANT CREATE TABLESPACE TO "C##YELLOWCOM" ;
GRANT DROP ANY TYPE TO "C##YELLOWCOM" ;
GRANT CREATE ANY SYNONYM TO "C##YELLOWCOM" ;
GRANT DROP ANY SYNONYM TO "C##YELLOWCOM" ;
GRANT EXECUTE ANY PROCEDURE TO "C##YELLOWCOM" ;
GRANT CREATE SYNONYM TO "C##YELLOWCOM" ;
GRANT CREATE SEQUENCE TO "C##YELLOWCOM" ;
GRANT DROP ANY INDEX TO "C##YELLOWCOM" ;
GRANT EXECUTE ANY OPERATOR TO "C##YELLOWCOM" ;
GRANT UPDATE ANY TABLE TO "C##YELLOWCOM" ;
GRANT DROP ANY VIEW TO "C##YELLOWCOM" ;
GRANT ALTER ANY TRIGGER TO "C##YELLOWCOM" ;
GRANT CREATE ANY VIEW TO "C##YELLOWCOM" ;
GRANT READ ANY TABLE TO "C##YELLOWCOM" ;
GRANT INSERT ANY TABLE TO "C##YELLOWCOM" ;
GRANT ALTER ANY TYPE TO "C##YELLOWCOM" ;
GRANT DROP ANY PROCEDURE TO "C##YELLOWCOM" ;
GRANT CREATE ANY TRIGGER TO "C##YELLOWCOM" ;
GRANT CREATE ANY TABLE TO "C##YELLOWCOM" ;
GRANT CREATE ANY TYPE TO "C##YELLOWCOM" ;
GRANT CREATE PROCEDURE TO "C##YELLOWCOM" ;
GRANT ALTER ANY OPERATOR TO "C##YELLOWCOM" ;