DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: PROBLEM WITH PRIVILEGES

  1. #1
    Join Date
    Mar 2002
    Posts
    171
    Let me explain the problem I am facing:

    1)I have a user X who owns a package P1. I have a public synonym P1 for P1 and have granted ALL on P1 to PUBLIC.

    2)I have another user Y who can only see the package specification of P1 but not the package body. Why is that? What is the work around. Kindly help me out.


    [Edited by dbafreak on 05-06-2002 at 12:36 AM]

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    As long as Y has EXECUTE permission on the package, you're all set.
    Jeff Hunter

  3. #3
    Join Date
    Mar 2002
    Posts
    171
    Originally posted by marist89
    As long as Y has EXECUTE permission on the package, you're all set.
    I have granted ALL. Why can't user Y see the body of the package but only the specification. What is the workaround?

  4. #4
    Join Date
    Mar 2002
    Posts
    171
    Extending my explanation - when I log in as user Y and select text from all_source I can only see the specification. I dont see the body though I have granted ALL on the package P1.

    I am also using TOAD through which I cannot see the code for P1 if I log in as Y. Please help me resolve the issue.


  5. #5
    Join Date
    Mar 2002
    Posts
    171
    Its strange that none so far even commented, let alone whether at all there is any solution. Kindly atleast pass some comments as to whether there could be a feasible solution.

  6. #6
    Join Date
    Mar 2002
    Posts
    171
    Its strange that none so far even commented, let alone whether at all there is any solution. Kindly atleast pass some comments as to whether there could be a feasible solution.

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    dont spam please

  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by dbafreak
    Its strange that none so far even commented, let alone whether at all there is any solution. Kindly atleast pass some comments as to whether there could be a feasible solution.
    Sure there is a feasible sollution.

    It sounds strange, but user can only see the source code of a package body in ALL_SOURCE if
    a) he owns the package
    or
    b) he has been granted CREATE ANY PROCEDURE system priviledge

    So grant CREATE ANY PROCEDURE to your user Y, either directly or through some role, and he'll be able to see the source code of package body P1.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  9. #9
    Join Date
    Mar 2002
    Posts
    171
    Originally posted by jmodic
    Originally posted by dbafreak
    Its strange that none so far even commented, let alone whether at all there is any solution. Kindly atleast pass some comments as to whether there could be a feasible solution.
    Sure there is a feasible sollution.

    It sounds strange, but user can only see the source code of a package body in ALL_SOURCE if
    a) he owns the package
    or
    b) he has been granted CREATE ANY PROCEDURE system priviledge

    So grant CREATE ANY PROCEDURE to your user Y, either directly or through some role, and he'll be able to see the source code of package body P1.

    Excellent!! the CREATE ANY PROCEDURE worked for me. Indeed its a little bizarre that none here (including gurus) could come out with this answer in the last 2 days. Thanks anyways.

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