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
Post a Comment