Hi folks,

Wondering if anyone can help with an api grant issue i‘m stuck with? 

Created few procedures within a package on test db, one named as drop_table_ as below (meant for deleting a temporary table content, not dropping as name suggest )

Create or replace package body CB_SALES_QUOTATION_API is
 procedure drop_table_  IS
  Begin
    EXECUTE IMMEDIATE 'DELETE FROM ifsapp.CB_NOTE_TEXT_TAB
     where CF$_NOTE_TEXT is not null';
  end drop_table_;

Executing this package via Custom menu rmb which works well with IFSAPP schema .But when i tried executing as a end user i get below message:

So far:

• Granted Package access to the user:

        Grant execute on ifsapp.CB_SALES_QUOTATION_API to XXX;

         Also, Grant execute on ifsapp.CB_SALES_QUOTATION_API to PUBLIC;

• Granted table access to the user:

         Grant all on ifsapp.CB_NOTE_TEXT_TAB to XXX;

Re-logged in as user but still getting above error message on IFS.Strangely, when i use PLSQL dev,

logged in as same user i can execute the api and also delete the table content but not on IFS client using custom menu. 

Any ideas?

Thanks in advance