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