Home
The application - Do you understand the danger, and change permissions so "Schema Changes" can only be done by the "Schema Master"?
  v4.0 Posted at 20/10/2010 7:57 PM by System Account
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

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address:

    Comments: