开发者

What can be implemented to prevent any tables from being changed? [closed]

开发者 https://www.devze.com 2023-03-14 16:39 出处：网络

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references,or expertise, but this question will likely solicit debate, a

相关专题：sql sql-server

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and p开发者_如何学编程ossibly reopened, visit the help center for guidance. Closed 11 years ago.

Q2. You want to prevent changes to tables in one of the databases in your SQL Server instance since changes to any of the tables can cause the associated client application to stop functioning. What can be implemented to prevent any tables from being changed? a. A stored procedure b. A database‐level DDL trigger c. A DML trigger d. A server‐level DDL trigger

thanks

Proper security.

Don't give your app accounts with owner rights.