Data Management:Manage permissions

Manage permissions as data owners, administrators, and DBAs

1. Log on to the DMS console V5.0.

2. In the top navigation bar, choose Database Assets > Instances.

   Note

   If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner of the DMS console and choose All functions > Data Assets > Instances.

3. On the Database List tab, find the database that you want to manage. In the Actions column, choose More > Permission Management.

4. Manage permissions on databases, tables, and columns.

   • Revoke permissions

     Select the user from which you want to revoke permissions and click Recycle Permission above the user list. In the dialog box that appears, configure the Permission parameter and click OK.

   • Grant permissions

     • Grant permissions on databases

       Click Grant Permissions on Database. In the dialog box that appears, select the user to whom you want to grant permissions, and configure the Permission and Expire Date parameters. Then, click OK.

     • Grant permissions on tables

       Click Grant Permissions on Table. In the dialog box that appears, select the table and the user to whom you want to grant permissions, and configure the Permission and Expire Date parameters. Then, click OK.

       Note

       The users to whom you want to grant permissions must already exist in DMS. For more information about how to add a user, see Manage users.

Manage permissions as common users

Common users can only release existing permissions on databases and tables.

1. Log on to the DMS console V5.0.

2. In the top navigation bar, click Security and Specifications. In the left-side navigation pane, choose Permission Center Permissions.

   Note

   If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner of the DMS console and choose All functions > Security and Specifications > Permission Center > Permissions.

3. On the Ordinary Permissions tab, click the first drop-down list and select the permission type to be released.

4. Select the resource on which you want to release permissions and click Release Permission. In the dialog box that appears, configure the Permission parameter and click OK.

1. Log on to the DMS console V5.0.

2. In the top navigation bar, click O&M. In the left-side navigation pane, click Users.

   Note

   If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner of the DMS console and choose All functions > O&M > Users.

3. Manage permissions on instances, databases and tables for users.

   • Revoke permissions

     1. Find the user whose permissions you want to revoke, move the pointer over More in the Actions column, and then select Permission Details.

     2. On the Ordinary Permissions tab, click the first drop-down list and select the permission type that you want to revoke.

     3. Select the resource on which you want to release permissions and click Release Permission. In the dialog box that appears, configure the Permission parameter and click OK.

   • Grant permissions

     Note

     The users to whom you want to grant permissions must already exist in DMS. For more information about how to add a user, see Manage users.

     1. Move the pointer over Authorize in the Actions column.

     2. Select the resource type to which you want to grant permissions.

     3. In the Authorize instance dialog box, configure the Permission and Expire Date parameters, and click OK.