User Management
Multiple users with different permissions can be created to access a DB instance or database, but the permissions of these users cannot exceed the operation permissions of the account.
Creating a User
- Click
in the upper left corner and select a region and project.
- Click
in the upper left corner, and under Databases, click Data Admin Service.
- In the navigation pane on the left, choose Development Tool.
- Locate the DB instance that you want to log in to and click Log In in the Operation column.
- On the top menu bar, choose Account Management > User Management.
- Click Create User. On the displayed page, enter the user information, such as basic information, basic permissions, extended permissions, and schema (optional), and select the read policy type.
Table 1 Basic permissions Permission
Description
CREATE
Permission to create databases for a specified object.
DROP
Permission to delete databases for a specified object.
ALTER
Permission to modify databases for a specified object.
INDEX
Permission to query indexes of a specified object.
INSERT
Permission to insert data into a specified object.
DELETE
Permission to delete data from a specified object.
UPDATE
Permission to update data of a specified object.
SELECT
Permission to query data of a specified object.
- Ensure that the settings are correct and click Save.
Editing a User
- Click
in the upper left corner and select a region and project.
- Click
in the upper left corner, and under Databases, click Data Admin Service.
- In the navigation pane on the left, choose Development Tool.
- Locate the DB instance that you want to log in to and click Log In in the Operation column.
- On the top menu bar, choose Account Management > User Management.
- In the user list, locate the user whose information you want to edit and click Edit in the Operation column.
- On the displayed page, edit basic information, basic permissions and extended permissions, and click Save.
Deleting a User
- Click
in the upper left corner and select a region and project.
- Click
in the upper left corner, and under Databases, click Data Admin Service.
- In the navigation pane on the left, choose Development Tool.
- Locate the DB instance that you want to log in to and click Log In in the Operation column.
- On the top menu bar, choose Account Management > User Management.
- In the user list, locate the user that you want to delete and click Delete in the Operation column.
- In the displayed dialog box, click Yes.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.