In Data Management (DMS), common users can apply for and release permissions. DMS administrators, database administrators (DBAs), or database owners can grant common users permissions on specific instances and revoke these permissions. In addition, a DMS administrator can grant permissions to or revoke permissions from multiple common users at a time.

Apply for permissions as a common user

This section shows you how to apply for the query permissions on a database as a common user. For more information, see Permission management.

  1. Log on to the DMS console.
  2. In the top navigation bar, choose Permission > Apply Permission > Database-Permission.
  3. On the Permission Application Ticket tab, enter the prefix of a database name in the field, set the parameters as required, and then click Search.
  4. Select the database that you want from the matched result and click Add. The database appears in the Selected Databases/Tables/Columns section.
    Add
  5. In the Select Permission section, set the parameters as required and click Submit. The following table describes the parameters.
    Submit
    Parameter Description
    Permission The type of permission for which you want to apply. Valid values: Query, Export, and Change.
    Note You can select one or more permission types.
    Duration The validity period of the selected one or more permissions.
    Reason The description of the business background and the reason for this application. This reduces unnecessary communication and facilitates the approval process.
    Note After a permission application ticket is submitted, wait until the ticket is approved. You can view the status of the ticket in the My Tickets section of the Workbench tab.

Release permissions as a common user

A common user can release permissions before the permissions expire. This section describes how to release permissions on a database within the validity period.

  1. Log on to the DMS console.
  2. In the top navigation bar, choose Permission > Permissions.
  3. On the Permissions tab, enter the prefix of a database name in the field, set the parameters as required, and then click Search.
  4. Select the database that you want from the matched result and click Release Permission.
    Permissions
  5. In the Permission Operation dialog box, select one or more types of permissions that you want to release and click OK.
    Permission Operation

Manage permissions of a user as a DMS administrator

This section shows you how to grant a user permissions on a database and revoke these permissions as a DMS administrator.

  1. Log on to the DMS console.
  2. In the top navigation bar, choose System > User.
    To grant permissions, perform the following steps:
    1. Find the user that you want, move the pointer over Authorize in the Actions column, and then select Authorize database.
      Note For information about how to add a user, see User management.
      Grant permissions to a single user as a DMS administrator
      Note You can also select multiple users at a time, click Authorize user at the top of the tab, and then select Authorize database, as shown in the following figure.Grant permissions to multiple users at a time as a DMS administrator
    2. In the Authorize database dialog box, set the parameters as required and click OK. The following table describes the parameters.
      Grant permissions on a database as a DMS administrator
      Parameter Description
      Authorized Database The database on which you want to grant the specified user permissions.
      Note You can select one or more databases.
      Permission The type of permission that you want to grant. Valid values: Query, Export, and Change.
      Note You can select one or more permission types.
      Expire Date The date on which the selected one or more permissions expire.
    To revoke permissions, perform the following steps:
    1. Find the user that you want, move the pointer over More in the Actions column, and then select Permission Details.
      Permission Details
    2. In the User Permissions dialog box, select the database that you want and click Release Permission.
      Revoke permissions as a DMS administrator
    3. In the Permission Operation dialog box, select one or more types of permissions that you want to revoke and click OK.

Manage permissions on a database as a DBA

This section shows you how to grant a user permissions on a database and revoke these permissions as a DBA. The operations in this section can also be performed by a DMS administrator.

  1. Log on to the DMS console.
  2. In the top navigation bar, choose System > Instance.
  3. Find the database that you want and click Details in the Actions column.
  4. On the Database List tab, find the database that you want, move the pointer over More in the Actions column, and then select Permission Management.
    Manage permissions as a DBA
    Note
    • You can grant permissions on multiple databases at a time. On the Database List tab, select the multiple databases and click Authorize user at the top of the tab.Grant permissions on multiple databases at a time as a DBA
    • You can revoke permissions on multiple databases at a time. On the Database List tab, select the multiple databases and click Recycle Permission at the top of the tab.Revoke permissions on multiple databases at a time as a DBA
    To grant permissions, perform the following steps:
    1. In the Permission Management dialog box, click Grant Permissions on Database.
      Grant Permissions on Database
    2. In the Authorize user dialog box, set the parameters as required and click OK. The following table describes the parameters.
      Parameter Description
      Add User The user to whom you want to grant permissions on the database.
      Note You can select one or more users.
      Permission The type of permission that you want to grant. Valid values: Query, Export, and Change.
      Note You can select one or more permission types.
      Expire Date The date on which the selected one or more permissions expire.
    To revoke permissions, perform the following steps:
    1. In the Permission Management dialog box, find the user that you want and click Recycle Permission in the Actions column.
      Recycle Permission
      Note To revoke permissions of multiple users on the database at a time, select the multiple users and click Recycle Permission, as shown in the following figure.Revoke permissions of multiple users at a time as a DBA
    2. In the Permission Operation dialog box, select one or more types of permissions that you want to revoke and click OK.

Manage permissions on a database as a database owner

This section shows you how to grant a user permissions on a database and revoke these permissions as a database owner. The operations in this section can also be performed by a DMS administrator.

  1. Log on to the DMS console.
  2. In the Owned Databases/Tables section of the Workbench tab, click Logical/Physical DB.
    Logical/Physical DB
  3. On the Owned Databases/Tables tab, find the database that you want and click Permission Management in the Actions column.
    Permission Management
    Note To grant permissions on multiple databases to a user at a time, select the multiple databases and click Authorize user, as shown in the following figure.Grant permissions on multiple databases at a time as a database owner
    To grant permissions, perform the following steps:
    1. In the Permission Management dialog box, click Grant Permissions on Database.
      Grant Permissions on Database
    2. In the Authorize user dialog box, set the parameters as required and click OK. The following table describes the parameters.
      Parameter Description
      Add User The user to whom you want to grant permissions on the database.
      Note You can select one or more users.
      Permission The type of permission that you want to grant. Valid values: Query, Export, and Change.
      Note You can select one or more permission types.
      Expire Date The date on which the selected one or more permissions expire.
    To revoke permissions, perform the following steps:
    1. In the Permission Management dialog box, find the user that you want and click Recycle Permission in the Actions column.
      Recycle Permission
      Note To revoke permissions of multiple users on the database at a time, select the multiple users and click Recycle Permission, as shown in the following figure.Revoke permissions of multiple users at a time as a database owner
    2. In the Permission Operation dialog box, select one or more types of permissions that you want to revoke and click OK.