Revert back specific permission/privileges of a user

Posted by Professionaluser under Sql Server category on 3/21/2016 | 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

Bookmark It

Latest Code Snipptes