reg - insufficient privilges when create view of table which resides in diff schema
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?