What is a data schema in Oracle?

D

Dom Topor2013-11-27 05:35:09

Oracle

Dom Topor, 2013-11-27 05:35:09

What is a data schema, how to create it, how to create a new user and grant him rights in Oracle DBMS?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander Lebedev, 2013-11-27
@deleted-Ari100teLL

Roughly speaking, the scheme is the user and his objects.
Create user VASYA identified by PAROL;
and grant rights:
grant connect to vasya;
also give quotas for tabular spaces.
http://docs.oracle.com/cd/E11882_01/timesten.112/e21642/state.htm#TTSQL304
http://docs.oracle.com/cd/E11882_01/server.112/e10897/users_secure.htm#ADMQS12001
In general, I think if you search on this topic you will find something to read.