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.
- 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.