Monday, May 25, 2015

Schema user

Dear my readers,  now I'd like to explain create schema user

the steps as following:
1- create user
2- assign password
3- assign default tablespace
4- give grant

create database user
create user test identified by test default tablespace users;

grant dba,resource to test;

conn test/test@orcl

hope all my post useful for all whom read my blog
Yasser

No comments:

Post a Comment