User should be able to read all the objects of an user [message #522529] |
Mon, 12 September 2011 00:25 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
lg123
Messages: 225 Registered: August 2008
|
Senior Member |
|
|
User A contains tables, views, LOB's, types, procedures, triggers, sequences, indexes, synonyms. User B wants to have read-only privilege on the objects of User A.
I can provide select on privilege on tables and views. How about providing read-only privileges to other objects?
|
|
|
Re: User should be able to read all the objects of an user [message #522530 is a reply to message #522529] |
Mon, 12 September 2011 00:57 ![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: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You do not give read privilege on triggers, indexes or synonyms, this is meaningless (actually you can grant select on a synonym of a table but you then give select on the pointed table not on the synonym).
It is also meaningless to have a read privilege on a procedure, a procedure can do only ONE thing: execute itself but is "execute" a read privilege?
Regards
Michel
|
|
|