how to deny delete permissions from set of tables for a part
how to deny delete permissions from set of tables for a particular user.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Chintan RathodPosted Dec 2, 2012, 3:32 AM
You can use
DENY DELETE ON TableName TO UserName
Microsoft provided a good library to deny object permission.
Thanks.