Ads

06 March 2015

KILL permissions on SQL SEREVER

Here You Go:

Example:

USE [master]
GO
CREATE LOGIN [TestUser] WITH PASSWORD=N'testuserpassword' 
GO
GRANT VIEW SERVER STATE TO TestUser
GO
GRANT ALTER ANY connection TO TestUser
GO

No comments:

Post a Comment