Facing Execute permission denied error on UDF intermitently

• Giridhar A

  SSC Veteran

  Points: 236

  More actions

  September 17, 2011 at 8:17 am

  #243295

  Hi ,

  My application in prod fails everyday at a particualr time with the error

  EXECUTE permission was denied on the object "UDF_GetName",

  it runs fine during other timings, could some one please help?

  Thanks,

  Giri

• paul_ramster

  Ten Centuries

  Points: 1382

  More actions

  September 17, 2011 at 10:11 am

  #1382933

  What else happens at the time that this function gives the error?

  Is there possibly a script running that DROPs and reCREATEs the function, but doesn't apply permissions for a finite period of time?

• shatrughna

  Ten Centuries

  Points: 1037

  More actions

  September 18, 2011 at 12:05 am

  #1383043

  Hi,

  It seems role issue on user.

  Check your any other script revoking role on this user.

  Shatrughna