This topic introduces how to implement database changes in project collaboration.
Background information
Web ODC V4.2.0 allows users who have the project creation permission to create projects and add project members. Project members can add and change databases in their projects.
Principle
The ODC system administrator grants a user the project creation role. The user creates a project and adds project members.
The project administrator or DBA member adds a database.
A project member initiates a ticket to apply for database changes.
ODC checks the risk level of the ticket based on the risk level identification rules and executes the review process based on the risk level.
After the ticket is approved, ODC automatically executes the database change or a user manually executes the database change.
Create a project
The system administrator grants the project creation permission to a user.
The project administrator creates a project and adds project members.
Note
ODC users with the project creation permission can create projects. By default, the project creator is granted the project administrator role. After the project administrator adds ODC users to a project as project members, the project members can access the project and perform team collaboration for the project after they log on to ODC.
Manage databases
Click the project name to go to the Project Management page.
Add a database on the Databases page.
A project member can export data from, import data to, change, and log on to the database, and transfer the database to another project.
Manage tickets
A project member without the database edit permission can submit tickets to apply for data export, data import, data simulation, database change, lock-free schema change, SQL plan, and data archiving operations.
Manage members
A project administrator can add, edit, and remove project members on the Members page.
Set projects
The project administrator can modify the project name and archive projects on the Settings page.