grantsecurity.sql

< SQL Server2005程序设计>

-- Before running: change 'DataServer' to your server name
USE master
GO
EXEC sp_grantlogin @loginame='DataServer\AdventureWorksSalesTeam'
EXEC sp_grantdbaccess @loginame='DataServer\AdventureWorksSalesTeam'
GO
USE [AdventureWorks]
GO
GRANT EXECUTE ON [dbo].[GetStoreContacts] TO [DataServer\AdventureWorksSalesTeam]
GRANT EXECUTE ON [dbo].[GetStoreInfo] TO [DataServer\AdventureWorksSalesTeam]
GRANT EXECUTE ON [dbo].[GetStoreRecentOrders] TO [DataServer\AdventureWorksSalesTeam]
GRANT EXECUTE ON [dbo].[ufnGetStoreSalesYTD] TO [DataServer\AdventureWorksSalesTeam]
GO
USE master
GO
GRANT CONNECT ON ENDPOINT::AdventureWorks TO [DataServer\AdventureWorksSalesTeam]
GO