Executing Procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Executing Procedure

  1. #1
    Join Date
    Apr 2001
    Posts
    112

    Executing Procedure

    I have a procedure that does an update to a table owned by a user A.
    I create a public synonym for this procedure and grant execute on this procedure to a Role which is then granted to User B.

    The update successfully happens through the procedure if UserA (owner) runs the procedure but the procedure runs fine WITHOUT doing the update if USerB runs it. If we drop and recreate the synonym and then if uSerB runs this procedure the update goes through.

    We have other similar procedures that run fine through the above process but this one seems to have problems.

    Do you have any thoughts.

    thx

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Re: Executing Procedure

    Originally posted by tansdot
    I have a procedure that does an update to a table owned by a user A.
    I create a public synonym for this procedure and grant execute on this procedure to a Role which is then granted to User B.

    thx
    Try granting the excute priveledge directly to the user B rather that through a role..

    regards
    Hrishy

  3. #3
    Join Date
    Jan 2002
    Posts
    78
    Is USERA granted the UPDATE privilege to that table to the ROLE or to the USERB ???

  4. #4
    Join Date
    Apr 2001
    Posts
    112
    But you know, the similar behavior works for all the other procedures.

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    can you post the source code of that proceedure .

    regards
    Hrishy

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: Re: Executing Procedure

    Originally posted by hrishy
    Try granting the excute priveledge directly to the user B rather that through a role..

    regards
    Hrishy
    Really dosent matter as far as the PROC that need to executed is not being called in another PROC or Trigger or any stored PL/SQL code.

    Originally posted by Sekhar

    Is USERA granted the UPDATE privilege to that table to the ROLE or to the USERB ???
    This is immaterial.

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #7
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405

    Re: Executing Procedure

    Originally posted by tansdot
    I have a procedure that does an update to a table owned by a user A.
    I create a public synonym for this procedure and grant execute on this procedure to a Role which is then granted to User B.

    The update successfully happens through the procedure if UserA (owner) runs the procedure but the procedure runs fine WITHOUT doing the update if USerB runs it. If we drop and recreate the synonym and then if uSerB runs this procedure the update goes through.

    We have other similar procedures that run fine through the above process but this one seems to have problems.

    Do you have any thoughts.

    thx
    Did you use "authid" in your procedure???
    -nagarjuna

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