对象'tablename'，数据库'db1'，schema'dbo上的SELECT权限被拒绝 [英] SELECT permission denied on object 'tablename', database 'db1', schema 'dbo

问题描述

大家好我已经搜索了很多这个错误

对象'tablename'拒绝SELECT权限，数据库'db1'，架构'dbo

但是我没有得到确切的答案，我无法理解问题的确切位置，为什么它会显示此错误以及解决方案是什么......

Plz帮助/回复我....

Hi every one i have search a lot for this error
"SELECT permission denied on object 'tablename', database 'db1', schema 'dbo"
but m not getting exact answer, m not able to understand the where the problem lies exactly, why its shows this error and what is solution for that...
Plz help/reply me....

推荐答案

这是因为您无权在该表上执行SELECT。请你的dba给你许可。



授予权限sql-script：

This is because you don't have permission to do SELECT's on that table. Ask your dba to give you permission.

Grant permission sql-script:

GRANT INSERT, UPDATE, SELECT ON YourTable TO User1, User2

< br $> b $ b

在SQL Server中授予和删除权限 [ ^ ]

我通过在安全性，登录下引用登录用户的属性来解决这个问题。然后转到用户映射并选择数据库，然后选中 db_datareader 和 db_dataweriter 选项。

I solved this by referring properties of login user under the security, logins. then go to User Mapping and select the database then check db_datareader and db_dataweriter options.

这篇关于对象'tablename'，数据库'db1'，schema'dbo上的SELECT权限被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！