Reputation
Top tag
Next privilege 50 Rep.
Comment everywhere
Badges
4
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
May
23
awarded  Popular Question
Oct
3
awarded  Scholar
Oct
3
accepted SQL Server, remove all users' access right to a table object
Jun
14
comment SQL Server, remove all users' access right to a table object
Thanks @Shark. This works and does the job, but I was looking to see if there's an admin command that can avoid using cursor. As an analogy, one can delete rows, but there's also the truncate command. I still up vote your answer though.
Jun
13
awarded  Supporter
Jun
13
awarded  Student
Jun
13
asked SQL Server, remove all users' access right to a table object