How can I manage multiple developers using the system administrator account? _ MySQL

Source: Internet
Author: User
Q: In our development environment, everyone has a system administrator (sa) password, and five groups use one database. After a developer accidentally deletes the data, I cannot determine which data to delete. When a developer updates data in a database, how does one review the workstation or login ID? A: Because you are working in the development environment, you can use the SQL event probe and the system administrator.

Q: In our development environment, everyone has a system administrator (sa) password, and five groups use one database. After a developer accidentally deletes the data, I cannot determine which data to delete. When a developer updates data in a database, how does one review the workstation or login ID?

A: Because you are working in a development environment, performance loss caused by SQL event probe and server tracking does not affect the production environment, you can set a server trace, record the information in the background in a table. Then, you can search for the table to determine who deleted the data.

Obviously, assigning sa accounts to multiple users at a time poses many problems. The following are some measures you should take:

Create a copy of the database for each development team and provide each team with an account that only has access to the database owner. In this way, they will not affect each other.
If every Developer needs sa access (for example, running SQL event probe tracing) and you are running SQL Server 2000 Enterprise or Developer Edition, you can provide each team with an SQL Server instance and its dedicated sa password.
You need to set up a development environment for each project and manage the conflicts among all projects in an integrated environment by a version database administrator. In this case, because the architecture change script has been tested before entering the integration environment, the quality of the production version will be improved.

-The Microsoft SQL Server Development team

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.