| Schema and User [message #54759] |
Tue, 03 December 2002 15:26  |
Amit
Messages: 166
Registered: February 1999
|
Senior Member |
|
|
Hi !
A user is associated with a schema. Can many users be associated with the same schema ? ( using synonyms perhaps ? ) Can u explain how exactly it takes place ?
Thanks and regards
Amit
|
|
|
|
| Re: Schema and User [message #54764 is a reply to message #54759] |
Wed, 04 December 2002 00:27  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
Basically, there's no real difference between a schema and a user. Logically the difference is that a schema is a 'collection of DB objects' while a user has access to its own and (optionally) to other DB objects. So, you cannot associate more users to one schema. I think the best way to grant access to several users is to use synonyms and grants. The easiest way is to create a public synonym for each object you want to be accessible to more users. Of course, you can create private synonyms too, but that will increase maintenance. You also need to grant access to the objects. Mostly this is done through roles: you create a role and grant the desired access to the objects to the role. Afterwards, you grant the role to the users concerned. This has a drawback however, if one of the other users creates a stored procedure through which he/she uses one or more 'remote' objects, Oracle won't recognize the grant. In that case, the grant should be given directly.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
