对象'tablename'，数据库'db1'，schema'dbo上的SELECT权限被拒绝

本文介绍了对象'tablename'，数据库'db1'，schema'dbo上的SELECT权限被拒绝的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

大家好我已经搜索了很多这个错误 对象'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

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.