Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
SOA - General Best Practices
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jun 20, 2012 7:18 AM by
Jun 20, 2012 4:50 AM
As far as I know schema is just a layout of database and one DB can have as many schemas as needed.
so, can there be more than one users for a schema?
and can one user be owner of many schemas??
This content has been marked as final.
Show 1 reply
Re: Schema configuration
Jun 20, 2012 7:18 AM
in response to
A user and a schema are pretty much the same. For each user you can give privileges to use objects owned by other users/schemas.
This means that a user can access multiple schemas depending on the privileges given.