i have two user schemas.
Let's Say A & B.
A has a procedure written in it SAY 'XProc'.
B has a package which has Procedure say 'B_Pack_Proc', which creates a dynamic view in B user schema.
The B_pack_proc creates view in B schema itself.
but i am executing the B_Pack_Pro from A, i am getting error insufficient privileges.
I am using oracle forms 11g and oracle DB 11g.
i have granted explicit grants to User A from User B
i.e Create any view
Execute on view.