Haneef Puttur

Create New Schema in Oracle 11G express

In order to create a new schema in oracle 11G express, we need to create a user account and assign all the privileges.

Step 1 : Open SQL command Line

Step 2 :

Run Connect

Step 3 :

Enter Username : SYSTEM

Step 4 :

Enter Password for The SYSTEM account , which is specified while installing oracle

Step 5 :

Create a new user called Haneef_Puttur with Password : test1000

create user haneef_puttur identified by test1000;

Step 6 :

Assign permission to the newly created user.

grant CREATE SESSION, ALTER SESSION, CREATE DATABASE LINK, -
 CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM, -
 CREATE ROLE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, - 
 CREATE TRIGGER, CREATE TYPE, CREATE VIEW, UNLIMITED TABLESPACE -
 to haneef_puttur;

.

Exit mobile version