Data Management (DMS) assigns four resource roles to manage ownership and accountability: instance database administrator (DBA), instance owner, database owner, and table owner. Use this page to find who holds each role and to view the resources assigned to your account.
Resource roles at a glance
| Role | Assigned to | Permissions |
|---|---|---|
| Instance DBA | An instance | See Resource roles |
| Instance owner | An instance | View users granted permissions on the resource; grant and revoke permissions; query all data except fields at the medium and high sensitivity levels |
| Database owner | A database | View users granted permissions on the resource; grant and revoke permissions; query all data in the database except fields at the medium and high sensitivity levels |
| Table owner | A table | View users granted permissions on the resource; grant and revoke permissions; query all data in the table except fields at the medium and high sensitivity levels |
For a full description of each role, see Resource roles.
Quick reference
| What to view | Where to look |
|---|---|
| DBA of an instance | Right-click the instance in the left-side navigation pane → DBA |
| Owner of an instance | Right-click the instance in the left-side navigation pane → Instance Owner |
| Owner of a database | Data Assets → Global Search → search by keyword → Data Owner column |
| Owner of a table | SQL Console → Table List icon (upper-right corner) |
| Resources you own | Home tab → My Assets tab → select from the drop-down list |
View instance roles
Go to the DMS console V5.0.
In the left-side navigation pane, right-click the instance you want to check.
Select the role to view:
DBA — shows the database administrator of the instance.
Instance Owner — shows the owner of the instance.
View the owner of a database
Go to the DMS console V5.0.
In the top navigation bar, click Data Assets.
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. The owner is displayed in the Data Owner column.
View or change the owner of a table
Go to the DMS console V5.0.
Open the SQL Console tab for the instance that contains the table.
Click the
icon in the upper-right corner.
View resources you own
The Home tab lists all instances, databases, and tables assigned to your Alibaba Cloud account.
Go to the DMS console V5.0.
On the Home tab, scroll to the lower part of the page and click the My Assets tab.
From the left-most drop-down list, select what to view:
Owner's instance — instances you own.
My Databases — databases you own.
My Tables — tables you own.
As an owner, you can view the users who are granted permissions on the resource, grant permissions on the resource to other users, revoke granted permissions, and query all data in the resource except fields at the medium and high sensitivity levels.
What's next
Apply for permissions — request access to an instance, database, table, sensitive field, or row of data.