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

PHP – String Exists?

Posted on

Sometimes when working strings we need to know if a character or another string is within the string, this below will help. if (strpos($str, ‘.’) !== FALSE) { echo ‘Found it’; } else { echo "nope!"; } Reference: http://stackoverflow.com/questions/13577041/php-string-contains All information on this site is shared with the intention to…

Read More

C# GetData DataSet Function

Posted on

Great for populating just about anything you can databind. using System.Configuration; using System.Data.SqlClient; using System.Data; private DataSet GetData(string query) { SqlCommand cmd = new SqlCommand(query); using (SqlConnection con = new SqlConnection(connString)) { using (SqlDataAdapter sda = new SqlDataAdapter()) { cmd.Connection = con; sda.SelectCommand = cmd; using (DataSet ds = new…

Read More

PowerShell – Mass Rename Files / Directories

Posted on

Recently I needed to rename files and directories in a repository so I came up with the PowerShell script. NOTE: Use caution using this. cd "C:\Users\dkittell\Repos\TestRepo" Get-ChildItem -File -Recurse | Rename-Item –NewName { $_.name –replace " ","_" } # Replace space with underscore – Files Get-ChildItem -File -Recurse | Rename-Item…

Read More