Tuesday, March 27, 2012

Deleting or droping table

How can I prevent a table from being dropped or truncated
Thank you
MikeHi,
Do not Grant Delete / Drop / DB_OWNER / SYSADMIN privileges. he only way to
restrict this is by controlling the access rights.
Thanks
Hari
SQL Server MVP
"Mike Donnelly" <MikeDonnelly@.discussions.microsoft.com> wrote in message
news:6147B34D-CF28-4462-9953-A3A05F511D7F@.microsoft.com...
> How can I prevent a table from being dropped or truncated
>
> Thank you
> Mike|||Make sure the table is owned by dbo and make sure your users aren't members
of the symin, db_dlladmin or db_owner roles.
David Portas
SQL Server MVP
--

No comments:

Post a Comment