All Products
Search
Document Center

Manage permissions

Last Updated: May 11, 2020

This topic describes best practices for permission management on databases, tables, and users.

Manage permissions on databases and tables

Manage permissions as a data owner

  • Scope: the databases and tables owned by the currently logged on data owner.
  • Scenarios:
    • Revoke users’ permissions on a specified database or table.
    • Grant users permissions on a specified database or table.
  • Method: Click in the Owned Databases/Tables section on the homepage of the DMS Enterprise console. Find the target database and click Manage.
    • The following figure shows how to revoke the login permission.Revoke multiple users' permissions

Manage permissions as the administrator or DBA

  • Scope: the databases on all database instances in DMS Enterprise.
  • Scenarios:
    • Revoke users’ permissions on a specified database or table.
    • Grant users permissions on a specified database or table.
  • Method: Choose System Management > Instance Management. Locate the target database instance and click View in the Permission Details column.

Manage permissions as a common user

  • Scope: the databases and tables that the currently logged on common user has access to.
  • Scenarios:
    • Release permissions on a specified database, table, or field.
  • Method: Click in the Accessible Databases/Tables section on the homepage of the DMS Enterprise console. Find the target database or table and click Release Permission.

Manage permissions of users

Manage permissions as the administrator

  • Scope: the permissions of all users in DMS Enterprise.
  • Scenarios:
    • Revoke a specified user’s permissions on a database or table.
  • Method: Choose System Management > User Management. Locate the target user and click Permission in the Actions column.

Manage permissions as a common user

  • Scope: the permissions of the currently logged on common user.
  • For more information about the scenarios and method, see “Manage permissions as a common user” in the “Manage permissions on databases and tables” section.