Viewing 2 posts - 1 through 2 (of 2 total)
SELECT 'GRANT EXECUTE ON [' + CONVERT(VARCHAR(255),NAME) + '] TO FredGRP'
FROM sysobjects
WHERE xtype IN ('P', 'X', 'FN', 'IF')
The "EXECUTE" can NOT be granted on IF (inline table-valued-function).
March 31, 2010 at 2:47 pm
#1143487
Check this out:
http://blogs.msdn.com/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx
May 26, 2009 at 11:56 am
#1000077