Hope, you can help me.
I have a procedure in a package and I would like for some other user to see it an use it as he likes. So I tried to grant him an execute grant on that procedure. I used SQL:
grant execute on Package.Procedure to user;
and I get error: ORA-04042: procedure, function, package, or package body does not exist.
I don't get it. What am I doing wrong? By all examples that I found, this sholud be right...