Home Forums SQL Server 2008 SQL Server 2008 - General EXECTE permission on function RE: EXECTE permission on function
Ant-Green
SSC Guru
Points: 113445
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