View resource roles

• To view the resource role for a specific resource, see View resource roles.
• To see the resources you own, see My Assets.

View resource roles

1. Log in to DMS 5.0.

2. View the resource roles.
   • instance DBA: In the instance list on the left, right-click the target instance and select DBA to view the instance DBA.
   • instance owner: In the instance list on the left, right-click the target instance and select instance owner to view the instance owner.
   • database owner:
     1. In the top menu bar, choose Data Assets > Global Search.
     2. Enter a keyword in the search box and click Search to find the target database.
     3. In the database list of the search results, view the database owner in the data owner column of the target database.
   • table owner: In the SQL console, click the Table List icon in the extended toolbar in the upper-left corner of the page to view or edit the table owner.
     Note Only tables in an instance managed in security collaboration mode have a table owner.

My Assets

1. Log in to DMS 5.0.

2. On the Home tab, click the My Assets tab at the bottom of the page to view your resources.
   Note If you cannot find the My Assets tab, click the Settings (gear) icon on the right side of the page and select My Assets.
3. From the first drop-down list on the left, select Owner's instance, Owner's databases, or Owner's tables to view your resources.
   • Owner's instance: You are the owner of these instances.
   • Owner's databases: You are the owner of these databases.
   • Owner's tables: You are the owner of these tables.

   Note Owners can view who has permissions on their resources, grant or revoke permissions, and query data in the resource. This excludes data in medium- and high-sensitivity fields.