About the Developer database permissions configuration and the canonical database upgrade process __ Database

During the release of the new version of the project, some problems of database rights Management and database upgrade process specification were exposed. After the release of the real version, actually found that some scripts have not been executed, causing users to upgrade after the emergence of some bugs, has a very bad impact. The project team devoted a meeting to discuss this issue, the specific reasons are as follows: 1. Developers now have write access to the test database, which makes it possible for everyone to execute scripts in the test database, so that a developer executes the script directly in the test environment, but does not register, and the results do not detect problems during testing , but the release of some scripts was omitted when the real environment was released. 2. Some database stored procedures are not updated directly to the directory specified in VSTS, but are executed directly in the development version of the database, or executed in the test database, so that there is no baseline for judgment at the time of publication. In order to avoid such a situation in the future, it is recommended that the following provisions be followed: 1. Recover the developer's write access to the test database, the developer has only read access to the test database, and only read and write access to the development database. The Write permission for the beta database can only be specified by an employee who publishes a beta version. 2. Each change to the database is written as a script and is enlisted in the specified file and executed together when published. 3. For the update and new of stored procedures, the updated stored procedure must be updated to the specified directory in VSTS, as well as if a new stored procedure is required to join the specified directory in VSTS. 4. All database scripts are required to be fetched from the specified file when both beta and real versions are released, and stored procedures are taken from the specified directory.