SQL Server 2008 Grant Select Permission

sql sql-server database-permissions
OhWhen picture OhWhen · Jun 3, 2011 · Viewed 8.1k times · Source

I am having trouble adding a user to a test database I set up on my local machine. I have added the user fine but the user does not have permission to SELECT (Or anything else for that matter) on the database. I have tried gone the the permission tab under the server, the database, and the table (there is only one it is a very simple database just for testing) and selected grant for every single option yet it still does not work. I have also tried doing a Transact-SQL command like:

use testing

GRANT SELECT, UPDATE, DELETE, INSERT TO User

and a couple of other combinations that return successfully but I still do not have permission to select data from the table. Any suggestions?

Answer

Jeff Siver picture Jeff Siver · Sep 25, 2011

Add the user to the db_datareader role to give the user select access to all of the tables.

Related questions

Permissions required to run 'ALTER DATABASE SET SINGLE_USER' statement on SQL Server 2008

I've came across the case when the following statement throws an error saying it can't be executed because of the permission: ALTER DATABASE [{0}] SET SINGLE_USER WITH ROLLBACK IMMEDIATE Couldn't find anywhere on the web any information about the permissions …

Read More
User Granted Access to Stored Procedure but Can't Run Query

I am working on a product that runs an SQL server which allows some applications to login and their logins are granted permission to run a stored procedure- AND NOTHING ELSE. The stored procedure is owned by an admin; the …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More