June 11, 2017 at 6:46 am
How can I prevent users from Deleting data from all tables in a DB?
June 11, 2017 at 7:31 am
Rechana Rajan - Sunday, June 11, 2017 6:46 AMHow can I prevent users from Deleting data from all tables in a DB?
Instead of delete trigger that doesn't do anything.
😎
June 11, 2017 at 9:50 am
Eirikur Eiriksson - Sunday, June 11, 2017 7:31 AMRechana Rajan - Sunday, June 11, 2017 6:46 AMHow can I prevent users from Deleting data from all tables in a DB?Instead of delete trigger that doesn't do anything.
😎
Modify their rights (eg, DENY DELETE)
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
June 11, 2017 at 10:22 am
Phil Parkin - Sunday, June 11, 2017 9:50 AMEirikur Eiriksson - Sunday, June 11, 2017 7:31 AMRechana Rajan - Sunday, June 11, 2017 6:46 AMHow can I prevent users from Deleting data from all tables in a DB?Instead of delete trigger that doesn't do anything.
😎Modify their rights (eg, DENY DELETE)
Too simple 😉
😎
June 11, 2017 at 12:07 pm
I'm not sure if this is what you're after, but even simpler than the permissions update is to make the database read-only. Then nobody will be able to make any changes.
June 12, 2017 at 2:05 am
Thanks all for the reply.
This post helped me.
https://www.sqlservercentral.com/Forums/581296/Deny-delete-and-drop-permission-to-the-sql-user
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply