What are the steps to create  my own schema/user in sql  plus???

 I need to create my own schema for my final year project to be able to create table ,alter the and so on

can any one help me please?

 

At the first you must create a new user and define a password by this instruction

Create user username identified by 123; 

Then , Give permission to this user by this instruction

Grant dba to username; 

then

Connect username/passward; 

this passward I mean 123 that is define to the user above

 Then create your tables or view as you like inside this user that is created now

 

 

after log in with the sys or sys dba , write these codes

create user prod identified by prod;

grant dba,resource,connect , create session to prod;

this is all what you need 

 

 

At the first you must create a new user and define a password by this instruction

Create user username identified by 123; 

Then , Give permission to this user by this instruction

Grant dba to username; 

then

Connect username/passward; 

this passward I mean 123 that is define to the user above

 Then create your tables or view as you like inside this user that is created now

 

شكرررررررررررررا جزيلا

زجراكم الله خيرا

 

after log in with the sys or sys dba , write these codes

create user prod identified by prod;

grant dba,resource,connect , create session to prod;

this is all what 

thank you sooooooooo much