0

We have PowerBI Users that are now asking for access to our database as datareaders. I have added a new User, provided the Username/Password to them. However, I would like to block access to two specific tables due to sensitive information.

The entire database just uses dbo as the schema. How do I block access to specific tables?

Scott Scriver
  • 17
  • 4
  • Did you also make this new user a read-only user? (see: [Is there a simple way to add a read-only user?](https://dba.stackexchange.com/questions/298493/is-there-a-simple-way-to-add-a-read-only-user) ) Because you do not want a Power-BI user who is capable of updating your data. – Luuk Jan 07 '23 at 13:06

1 Answers1

4

A simple deny should be all you need to do:

deny select on object::dbo.<table> to <user>;
Stu
  • 30,392
  • 6
  • 14
  • 33