|
Re: schema [message #69500 is a reply to message #69498] |
Tue, 22 January 2002 03:27 |
Vijay Kamath
Messages: 4 Registered: January 2002
|
Junior Member |
|
|
S Schema can be considered as a user for the Oracle database.
A schema can be created the DBA as follows:
connect system/manager;
create user yourname identified by yourpassword;
Then grant connect and resource privileges to that schema:
grant select , resource to yourname
|
|
|
Re: schema [message #69540 is a reply to message #69498] |
Tue, 29 January 2002 13:51 |
Gajanan Kini
Messages: 8 Registered: January 2002
|
Junior Member |
|
|
NOTE
Just a caution.
Also mention to give the default tablespace and the temporary tablespace for that particular user
if u donot mention any thing then it will take as default tablespace as system
create user <username>
identified by <password>
default tablespace <ts_name>
temporary tablespace <ts_name>
GAJANAN P KINI
|
|
|