| muzu |
Posted: Aug 14, 2007 11:49:41 AM |
Total Post: 37
Joined: Aug, 2007
|
Whatis the actual difference between the schema and user? When a database is created the schemas 'system' and 'sys' are created along with the users sys and the system. Can anyone let me know about this difference?
Also when we create other users, how do we give access to those users to access the schema? |
|
|
 Vigyan |
| Posted: Aug 14, 2007 02:16:31 PM |  |
|
Total Post: 386
Joined: May, 2001
|
By definition, a user is someone who can connect to a database and the objects a user owns are collectively called schema.
Schema is always bound to exactly one user.
Hope it helps.
Vigyan
|
|
|
|
|
| Ramesh Joyisa |
| Posted: Aug 17, 2007 12:30:49 AM | |
|
Total Post: 246
Joined: Aug, 2007
|
To add to the above point, A schema is a collection of database objects under the control of a given database user.
|
|
|
|
|
| Mohammed Taj |
| Posted: Aug 18, 2007 02:53:00 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
In Addition....
SCHEMA equal to USER
USER equal to SCHEMA
Regards
Taj
|
|
|
|
|
| mohamed riaz |
| Posted: Jan 19, 2008 03:19:00 AM | |
|
Total Post: 95
Joined: Sep, 2006
|
Dear Taj,
how will you test the database in plsql or in general. can you explain in details. This is most urgent!!.
Regards
Mohamed Riaz
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
