The SELECT permission solution for object ' data ' (database ' xxx ', owner ' dbo ') was rejected

SELECT permission denied to object ' data ' (database ' xxx ', owner ' dbo ')

The workaround:

1> in the database corresponding user rights, the Db_denydatareader check box to remove the tick. A lot of beginners, always think in the database permissions to select

The more permissions you have, the greater the privileges. In fact, this is wrong. Db_denydatareader is denied access.

2> did not give sufficient permission when designing the database table

Give him the SELECT permission for the table.