sql server - Not allowing deletion of records by any user except through stored procedure -


i working on project , in 1 of tables want users (any user) not able delete rows, unless deletion done through stored procedure.

there question , has answer here https://stackoverflow.com/a/366931/4810628

but need know how enforce such policy in sql server.

thanks

remove (deny) everyone's permissions deletes table, add (grant) them permissions execute stored proc.


Comments