nem.ec

Programming Information Security Recipes Personal Code Snippets

Create an MS SQL user and grant permissions

CREATE LOGIN MyLogin WITH PASSWORD = '123'; 
CREATE USER Guru99 FOR LOGIN MyLogin
GRANT SELECT ON SCHEMA :: [dbo] TO myspecialrole
GRANT SELECT ON [dbo].[myarchivetable] TO myspecialrole