Database Administration (MOSC)

MOSC Banner

reg - insufficient privilges when create view of table which resides in diff schema

edited Mar 15, 2012 5:30AM in Database Administration (MOSC) 6 commentsAnswered ✓

schema A had tables

and it has select role

schema B (assigned schema A role to schema - i am trying to create view as select * from SCHEMA.A table   in schema B

its throwing error - insufficient privileges

however when I grant schema A table  directly to schema B am able to create view..but thru roles am  getting error.

I wanted to use roles..does anyone what is the issue?

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