Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insufficient privileges on tables from Package

user-xvxldJun 14 2023

Hello everybody

I hope you can help me. I have this table sales_user.client and this package billing_user.pk_management. The billing_user belongs to the billing _roluser role and this rol has query permissions (grant select) on the table., but when compiling the package I get the error PL/SQL: ORA-01031: insufficient privileges (on this table sales_user.client). If I query the table outside the package, everything works fine. what am I doing wrong?

Thanks a lot

Comments
Post Details
Added on Jun 14 2023
8 comments
1,895 views