Schema,User,Database [message #344435] |
Fri, 29 August 2008 15:55 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Hi friends,
Please tell me the relationship between Schema,User,Database.
All r same or slightly different or Completely different.
Please explain with any one example.. it may be to understand easily.
Thanks
Ramya
|
|
|
|
Re: Schema,User,Database [message #344457 is a reply to message #344435] |
Fri, 29 August 2008 20:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varunvir
Messages: 389 Registered: November 2007
|
Senior Member |
|
|
Schema and user is same .No difference.Database is a frame which is used by applications.Please go through the basics of oracle that is what my recommendation to you.
Regards,
Varun Punj,
|
|
|
|
|
Re: Schema,User,Database [message #344576 is a reply to message #344575] |
Sat, 30 August 2008 12:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68681 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Many entreprises users can share one database schema.
They were introduced in 8i (iirc), see Advanced Security Administrator's Guide of your version.
Regards
Michel
|
|
|