Insufficient privileges : Dynamic View Creation ORACLE
-
Hello, 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. please help.
- Prathamesh
-
Hello, 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. please help.
- Prathamesh
Have you given user A privileges to execute the package?
GRANT EXECUTE ON B.packagename TO A;
Wrong is evil and must be defeated. - Jeff Ello[^]
-
Have you given user A privileges to execute the package?
GRANT EXECUTE ON B.packagename TO A;
Wrong is evil and must be defeated. - Jeff Ello[^]
i have explicitly granted permission on the view, package and the tables in the views. still not working
- Prathamesh
-
i have explicitly granted permission on the view, package and the tables in the views. still not working
- Prathamesh
What's the exact error message?
Wrong is evil and must be defeated. - Jeff Ello[^]