| User should be able to read all the objects of an user [message #522529] |
Mon, 12 September 2011 00:25  |
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  |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
