开发者

SQL Server 2008 Grant Select Permission

开发者 https://www.devze.com 2023-03-10 09:37 出处:网络
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 d

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 testi开发者_如何学编程ng) 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?


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


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).

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号