Home » RDBMS Server » Security » User should be able to read all the objects of an user (AIX, 10.2.0.3)
User should be able to read all the objects of an user [message #522529] Mon, 12 September 2011 00:25 Go to next message
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
Michel Cadot
Messages: 66447
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
Previous Topic: Unable to see data in base table where as data can be viewed in synonym.
Next Topic: SYS Password
Goto Forum:
  


Current Time: Tue Jun 25 13:17:59 CDT 2019