Listing 3: Statements to Set Up the SQL Server Objects for the Web Service Application
USE master
EXEC sp_addlogin 
	@loginame = 'SSMWSLogin', 
	@passwd = 'passSSMWSLogin'
Use SSMWSEmpPhones
GO
EXEC sp_grantdbaccess 'SSMWSLogin'
GRANT EXECUTE ON LikeLname TO SSMWSLogin
GRANT EXECUTE ON UpdateEmpPhonesRow TO SSMWSLogin
GRANT EXECUTE ON ValidateNewPW TO SSMWSLogin
GRANT EXECUTE ON UpdatePassword TO SSMWSLogin
GO