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!

Execute permission on single procedure / function.

3342781Jun 25 2018 — edited Jun 26 2018

Dear Expert

Please suggest below.

I have given the execute permission on specific function to another user. And when I tried to execute the same function from that user, I am getting insufficient privileges.

How can i give the execute permission on one procedure / function to another user.

Steps Performed:

Conn /as sysdba

SQL>grant execute on SCOTT..EFS_GET_ACTIVE_COMPANIES to FINANCE ;

Grant succeeded.

SQL> conn FINANCE / FINANCE

Connected.

SQL> alter function SCOTT.EFS_GET_ACTIVE_COMPANIES compile;

alter function scott.EFS_GET_ACTIVE_COMPANIES compile

*

ERROR at line 1:

ORA-01031: insufficient privileges

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 24 2018
Added on Jun 25 2018
7 comments
4,100 views