Executing Procedure

[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

[hrishy]

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

[Sekhar]

Is USERA granted the UPDATE privilege to that table to the ROLE or to the USERB ???

[tansdot]

But you know, the similar behavior works for all the other procedures.

[hrishy]

Hi

can you post the source code of that proceedure .

regards
Hrishy

[abhaysk]

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.

[nagarjuna]

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???