EXECTE permission on function

• bala2

  SSCertifiable

  Points: 5547

  More actions

  November 15, 2012 at 3:05 am

  #393605

  Hi,

  HOw to grant execute permission to all "FUNCTIONS" on the database for particular "USER" ?

  please provide the script or command to do that.

  Thanks,

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  November 15, 2012 at 3:22 am

  #1559257

  Create a Role using CREATE ROLE

  Then grant execute on the functions to the role GRANT EXECUTE ON .... TO rolename

  Then add the user to the role sp_addrolemember rolename, username