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.

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.