var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Grant execute on one procedure
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...
You can only grant on the package itself, not the individual procedures or functions in the package.
Oki - I alrady know the answer.
It's not possible. Apperently It's possible only on package.