The application - Do you understand the danger, and change permissions so "Schema Changes" can only be done by the "Schema Master"?
20/10/2010 7:57 PM by
Having many people in a company that are able to make schema changes, can only lead to big problems. This gets worse if the application is powerful (eg. enabled with SSW SQL Deploy
that can make schema changes itself) can make schema changes.
Let's see how to fix the issue:
To avoid this problem, only one person (the "Schema Master") should have permissions to upgrade the database.
- Figure: The db_owner role is granted for one person only – the "Schema Master"
- Figure: And here is the "Schema Master" at SSW
Do you feel this rule needs an update?