(grant trouble) user wants to edit other user's package
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: (grant trouble) user wants to edit other user's package

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    20
    i granted execute on a packge to another user, but this other user wants to be able to edit the package body. is that possible?? how do i do that?? i granted the execution privilege to the role and also tried granting directly to the user... please help!!

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking alter procedure



    can't you just grant alter procedure to the user?

    - Magnus

  3. #3
    Join Date
    Sep 2000
    Posts
    20
    i granted alter any procedure to the user and still can't even see the package body.
    any other idea?? please....

  4. #4
    Join Date
    Nov 2000
    Posts
    344
    since the package is owned by another user, I think you need to grant 'alter any procedure' to the user that is going to edit it. Or possibly 'create any procedure', since the command to change a procedure starts with the word 'create', not 'alter'

  5. #5
    Join Date
    Sep 2000
    Posts
    20

    Smile

    granting create procedure worked!! thanks a lot!

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