• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

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
0
enrique_aeo
Asked:
enrique_aeo
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
connect as sales (or dbo), and run this:
deny select on sales.order to pat

Open in new window

0
 
Ephraim WangoyaCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now