CODEWITHSUNDEEP
sqlsql-server
KinsDotNet
KinsDotNet

Reputation: 1560

How can I grant a user limited permissions in SQL Server 2008?

I want my student assistant to be able to use SQL Server Management Studio to run basic queries to test them before using them in our application. I want her to be able to select from tables, but not to insert, delete, or truncate or anything that would otherwise affect our data.

Does anyone know how I might achieve this?

Upvotes: 0

Views: 43

Answers (1)

JohnLBevan
JohnLBevan

Reputation: 24410

use DatabaseCatalogue
go    
exec sp_addrolemember db_datareader, StudentAssistantsUsername 
go

http://technet.microsoft.com/en-us/library/ms188629(v=sql.90).aspx

Upvotes: 1

Related Questions