Create Read Only SQL User

Posted on March 30, 2015 By David Kittell

USE [master]
GO

CREATE LOGIN [LimitedUser]
	WITH PASSWORD = N'testPass'
		,DEFAULT_DATABASE = [master]
		,CHECK_EXPIRATION = OFF
		,CHECK_POLICY = OFF
GO

USE [DatabaseName]
GO

CREATE USER [LimitedUser]
FOR LOGIN [LimitedUser]
GO

USE [DatabaseName]
GO

GRANT SELECT
	TO [LimitedUser]
GO

All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.

Related

Code MSSQL SQL