Insufficient Privileges On A View
There is an interesting problem where I am stuck.
User C has a tableC .
User B has a viewB whose script is "select * from UserC.tableC". This works fine.
UserA has select privs both on viewB and tableC.
The problem is:
When I connect as userA and execute
"select * from UserC.tableC" it works fine but when I execute
"select * from UserB.ViewB" I get ora-01031 insufficient privileges error. As I said User A has select priv both on UserB.ViewB and UserC.tableC but I cant understand why it complains about insufficient privs.
Thanks.
Emrah