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!

Privilege required to view Stored procedure's source code

VitaminDJun 27 2014 — edited Jun 27 2014

RDBMS Version: 11.2.0.4

Platform : Oracle Linux 6.4

In our Production DB we have an application schema named CRM_PROD. And, we have a read-only user named steve in this DB.

Steve should be able to view the source code of all stored procedures , Functions and Packages in CRM_PROD schema. But steve shouldn't be able to execute these procedures , Functions and Packages in CRM_PROD schema. What privilege should I grant to Steve for this ?

This post has been answered by Billy Verreynne on Jun 27 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 25 2014

Added on Jun 27 2014

3 comments

1,760 views