Create Read Only SQL User

Posted on 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.
Code MSSQL SQL

Related Posts

Red Hat / CentOS / Fedora – Fix Yum Duplicates

Posted on

When nothing else seemed to work this helped me to get rid of all the duplicates from failed yum updates. yum update glibc -t –skip-broken package-cleanup –dupes –skip-broken package-cleanup –cleandupes –skip-broken updatedb sudo yum clean packages –skip-broken sudo yum clean headers –skip-broken sudo yum clean dbcache –skip-broken sudo yum clean…

Read More

Random Code/Number

Posted on

$Random_code=rand(); echo $Random_code; Originally Posted on August 15, 2013Last Updated on October 26, 2015 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…

Read More