Updated on 2026-11-03 GMT+08:00

Granting Database Permissions

Scenarios

You can grant an account you created permissions on specified databases and revoke those permissions as needed.

Constraints

  • This operation is not allowed for instances that are being restored.
  • An account with read-only or read/write permissions on all databases can still be granted read-only or read/write permissions on specific databases. The account's actual permissions are a combination of permissions on all and specific databases.
  • After multi-tenancy is enabled, you cannot grant or revoke permissions on multi-tenant databases through the console. If needed, connect to the instance using a client tool and execute SQL statements. For details, see Using Multi-Tenancy for Resource Isolation.

Procedure

  1. Log in to the TaurusDB console.
  2. Click in the upper left corner and select a region.
  3. On the Instances page, click the instance name.
  4. In the navigation pane, choose Databases. On the displayed page, locate the target database and click Authorize in the Operation column.
  5. In the displayed dialog box, select one or more unauthorized database users, and select the read-only or read/write permission in the Authorized Users area.

    Figure 1 Changing permissions

    If no users are available, you can create one by referring to Creating an Account.

  6. Click OK.