| schmea & users [message #62960] |
Sun, 29 August 2004 04:39  |
rajini
Messages: 3
Registered: July 2004
|
Junior Member |
|
|
hi what's the
differenece between schema and user
pls
rajini
|
|
|
|
| Re: schema & users [message #62963 is a reply to message #62960] |
Sun, 29 August 2004 21:49  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
- Go to the top of the page and click 'search'.
- Type 'Difference schema user' in the text box and click the submit button.
Anyway, it comes down to this:
A schema is a "container" for objects and a user is mostly a schema's owner.
So, a schema is the collection of objects owned by a user.
A user can connect to the database, a schema not.
A user can grant access to his schema to other users.
Look also here and here.
From the manuals:
----------------------------------------------------------------------
A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are the logical structures that directly refer to the database's data.
----------------------------------------------------------------------
[Updated on: Fri, 18 February 2005 23:32] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
