Skip to Main Content

SQL & PL/SQL

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!

Grant execute with read only to procedure/package

User_02RLIDec 16 2022 — edited Dec 16 2022

I have a user 'USER' and want to grant him access to procedure 'schema.p' in such a way that he can execute the procedure but can not edit it ?
I gave execute privilege, but he can edit the procedure.

Comments
Post Details
Added on Dec 16 2022
5 comments
698 views