Couldn't find Store procedure

• narayanaswamy

  SSC Enthusiast

  Points: 157

  More actions

  November 24, 2009 at 9:34 pm

  #99967

  Hi all,

  ABC store procedure owned by X user and he had execute permission on it. Now Y user trying to this ABC he is getting couldn't find mentioned stored procedure in the report console.

  I've execulsively granted Y to Exeucte permission for this user on SP level still doesn't work.

  Let me know how to resolve this issue.

• arun.sas

  SSChampion

  Points: 11831

  More actions

  November 24, 2009 at 9:40 pm

  #1083799

  Hi,

  Try to execute with full qualification of the procedure like

  Exec DB.Owner.MYPROCEDURE