Hi, everyone
We have 2 schemes ASSORT and DWH
In ASSORT schema I create store procedure and grant execute privilege on it to DWH:
create or replace procedure assort.my_proc is begin null; end;
grant execute on assort.my_proc to DWH;
Then I try to run the procedure logged as DWH user - and I got an error **PLS-00302: component** my_proc **must be declared**
begin
assort.my_proc;
end;
I checked the all_tab_privs - and I see that DWH user indeed has execure privilege on ASSORT.MY_PROC
What else can cause an error?