is there a way to prevent drop or truncate a specific table by admin ,
in sql server .
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.
PUNEET BISHTPosted Nov 8, 2012, 11:48 PM
because sometimes a table is accidently truncated or deleted,
making view is not a good idea.
if i make a trigger ,it is implemented in all tables in db.
i just want to implement it in specific tables,
Sivaraman DhamodaranPosted Nov 8, 2012, 8:08 AM
A normal user can not (Unless one more admin) prevent admin doing the same
Do you want to trouble your db admin :)