PRIVILEGES TO RUN A PROCEDURE/PACKAGE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: PRIVILEGES TO RUN A PROCEDURE/PACKAGE

  1. #1
    Join Date
    Dec 1999
    Posts
    217

    Angry

    I need to know what is the correct way of getting all users to run different schema owners procedures and packages.
    I have done the following:

    1. Created a public synonym for the proc/pkg.
    2. Given execute permissions to public.

    Is there anything else I need to know. Or else is there a better way of doing this? I am having problems with the users not being able to run the procedures/packages?
    ANy input on this would be greatly appreciated.

    Thanks,
    Chintz

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    What you have done is totally sufficient for your users to run those procedures. But even more important things about procedures is that the owners of the procedures have sufficient privileges themself! The owner of the procedure has to:

    a) be an owner of the all objects referenced by a procedure
    or
    b) has all the neccessery privileges on the referenced objects from other schemas granted *directly* to them, not granted through roles.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Dec 1999
    Posts
    217

    Smile

    Thanks for your reply. It is working fine. Those were the only steps.

    CHintz

Posting Permissions

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


Click Here to Expand Forum to Full Width