CODEWITHSUNDEEP
sqlsql-serverdatabase-permissions
OhWhen
OhWhen

Reputation: 91

SQL Server 2008 Grant Select Permission

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?

Upvotes: 2

Views: 8134

Answers (2)

Jeff S
Jeff S

Reputation: 7484

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

Upvotes: 3

user596075
user596075

Reputation:

Add the user to the public database role and they should be able to SELECT against the database (unless you have changed the public role's permissions).

Upvotes: 2

Related Questions