Background information
Web OceanBase Developer Center (ODC) V4.2.0 allows a user with the project creation permission to create a project and add members to the project. A project member can add and change databases in the project.
This topic describes how to implement database changes through project collaboration.
Technical mechanism
The ODC system administrator grants the project creation permission to a user. Then, the user can create a project and adds members to the project.
The project administrator or DBA adds a database to the project.
A project member initiates a database change ticket.
ODC determines the risk level of this ticket based on the risk level identification rules and selects the corresponding approval process for this ticket.
After the ticket is approved, the database change is automatically executed by ODC or manually executed by the user.
Project creation
Method 1: A user with the project creation permission creates a project
The system administrator grants the project creation permission to a user.
The project administrator creates a project and adds members to the project.
Note
An ODC user with the project creation permission can create projects. By default, the user who creates a project is granted the administrator role of this project. After the project administrator assigns ODC users as members of the project, the members can access this project after logging on to the ODC console with their own accounts, and work as a team in the project.
Parameter Description Project Name The name of the project. Administrator A user that manages all databases and members of the project. DBA A user that manages all databases of the project. Developer A user that can log on to all databases, execute SQL statements, and submit tickets, which is usually a developer. Security Administrator (Optional) A user that can manage only sensitive columns of the project and participate in review. Participant (Optional) A user that can participate only in review. Description (Optional) Additional information about the project.
Method 2: Join a project
An ODC user can click Apply for Project Permissions to join an existing project.
On the Projects or Tickets tab, click Apply for Project Permissions.
a. Apply for database permissions on the Projects tab.
b. Apply for project permissions on the Tickets tab.
Select the project, specify your role, enter the reason for application, and then click Create.
View the approval status on the Tickets tab.
View the project that you joined in the project list.
Database management
Method 1: A user with database permissions adds a database
Click the name of a project to go to the project management page.
Add a database.
A member can export data, import data, perform database changes, and log on to databases. The project administrator or DBA can change the project to which a member belongs.
Note
If a data source has been bound to a project, you cannot transfer the databases in the data source to other projects.
Method 2: Apply for database permissions
Notice
- To apply for database permissions, make sure that you have joined the corresponding project.
- You can apply for permissions on databases only in the project that you have joined.
You can apply for the query, export, and change permissions on databases.
On the Projects or Tickets tab, click Database Permission Application.
a. Apply for database permissions on the Projects tab.
b. Apply for project permissions on the Tickets tab.
In the Database Permission Application panel, select the project, databases, permission types, and permission validity period, enter the reason for application, and then click Create to create a database permission application.
Ticket management
A project member without the database editing permission can submit a ticket to execute a data export, data import, data mocking, database change, lock-free schema change, SQL plan, or data archiving task.
Member management
The project administrator can add, edit, or remove members as well as manage database permissions on the Members tab.
Message notification
A project member can specify the ticket events for which notifications are sent and add notification channels such as DingTalk, Feishu, WeCom, and custom webhooks on the Notification tab. When the corresponding ticket event occurs, ODC will send a change message to notify the project member. For more information, see Message notification management.
Project settings
The project administrator can rename the project and archive the project on the project settings page.
