Database Security Products (MOSC)

MOSC Banner

Insufficient Privileges On A View

edited Oct 8, 2009 4:51PM in Database Security Products (MOSC) 7 commentsAnswered ✓
Hello,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center