-
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!!
-
alter procedure
can't you just grant alter procedure to the user?
- Magnus
-
i granted alter any procedure to the user and still can't even see the package body.
any other idea?? please....
-
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'
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|