Data Management (DMS) provides the following resource roles: instance database administrator
(DBA), instance owner, database owner, and table owner. This topic describes how to
view resource roles.
Background information
Different resource roles have different permissions on resources. You can view the
owner of an instance, a database, or a table and the DBA of an instance. You can also
view the resources that are owned by your Alibaba Cloud account.
Procedure
This section describes how to view the owner of an instance, a database, or a table
and the DBA of an instance. You can also view the resources that are owned by your
Alibaba Cloud account on the Home tab of the DMS console. For more information, see
the View the resources that are owned by your Alibaba Cloud account section of this topic.
- Go to the DMS console V5.0.
- View resource roles.
- To view the DBA of an instance, right-click the instance in the left-side navigation
pane and select DBA.
- To view the owner of an instance, right-click the instance in the left-side navigation
pane and select Instance Owner.
- To view the owner of a database, perform the following steps:
- In the top navigation bar, click . In the left-side navigation pane, click Global Search.
- Enter a keyword in the search box and click the icon.
- In the search results, find the database that you want to view. The owner of the database
is displayed in the Data Owner column.
- To view or change the owner of a table, go to the SQL Console tab and click the icon in the upper-right corner.
Note Only the tables in an instance that is managed in Security Collaboration mode are
assigned an owner.
View the resources that are owned by your Alibaba Cloud account
- Go to the DMS console V5.0.
- In the lower part of the Home tab, click the My Assets tab.
- To view the instances, databases, or tables that are owned by your Alibaba Cloud account,
select Owner's instance, My Databases, or My Tables from the left-most drop-down list.
- Owner's instance: You are the owner of the instances.
- My Databases: You are the owner of the databases.
- My Tables: You are the owner of the tables.
Note The owner of a resource can view the users who are granted permissions on the resource.
The owner can grant permissions on the resource to a user and revoke the granted permissions
from the user. In addition, the owner can query all the data in the resource, except
for fields at the medium and high sensitivity levels.