create a user who should NOT have DELETE permission on a table TestTab

Professionaluser
Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 89
Suppose you need a database user(TestUser) who should NOT have DELETE permission on specific table data(TestTab).

DENY  DELETE ON dbo.TestTab to TestUser

Comments or Responses

Login to post response