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: 507
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