Home » RDBMS Server » Server Utilities » schema
schema [message #69498] Tue, 22 January 2002 03:16 Go to next message
muruganandham
Messages: 2
Registered: January 2002
Junior Member
please explain schema.
how to create schema?
Re: schema [message #69500 is a reply to message #69498] Tue, 22 January 2002 03:27 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Re: Recovery Problem
Next Topic: Re: Managing tablespace
Goto Forum:
  


Current Time: Thu Mar 28 10:33:41 CDT 2024