How can I grant read-only access to my SQL Server 2008 database?

Posted by Adrian Grigore on Server Fault See other posts from Server Fault or by Adrian Grigore
Published on 2011-01-10T15:18:06Z Indexed on 2011/01/10 15:55 UTC
Read the original article Hit count: 450

Hi,

I'm trying to grant read-only access (in other words: select queries only) to a user account on my SQL Server 2008 R2 database. Which rights do I have to grant to the user to make this work?

I've tried several kinds of combinations of permissions on the server and the database itself, but in all cases the user could still run update queries or he could not run any queries (not even select) at all. The error message I always got was

The server principal "foo" is not able to access the database "bar" under the current security context.

Thanks for your help,

Adrian

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2008