Revert back specific permission/privileges of a user

Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 740
For suppose, if you want to revert back the UPDATE and DELETE privileges on a specific table (TestTab) from a user TestUser use below query

REVOKE UPDATE, DELETE ON dbo.TestTab  to TestUser 

Comments or Responses

Login to post response