select permission to remove a table

I have 2 users database, pat  and ted
 how? remove the permission to read user table Pat sales.order
enrique_aeoAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
connect as sales (or dbo), and run this:
deny select on sales.order to pat

Open in new window

0
 
Ephraim WangoyaConnect With a Mentor Commented:
try using revoke


revoke select on OBJECT::sales.order from Pat
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
revoke would only remove the explicit permission, but not necessarily completely block the SELECT permission, if the permission has been granted via other roles, for example.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.