Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Slovenia
    Posts
    18

    Unhappy Grant execute on one procedure

    Hello!

    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...

    Thank you!
    www.SloMusic.com

  2. #2
    Join Date
    May 2006
    Posts
    132
    You can only grant on the package itself, not the individual procedures or functions in the package.

  3. #3
    Join Date
    Sep 2003
    Location
    Slovenia
    Posts
    18
    Oki - I alrady know the answer.
    It's not possible. Apperently It's possible only on package.

    Thank you!
    www.SloMusic.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •