A database owner is a resource role in Data Management (DMS) with administrative responsibility over a specific database. As an owner, a user can grant and revoke Query, Export, and Change permissions for other users on that database. This is distinct from users who receive those permissions through authorization: they can perform the specific operations, but cannot manage access for others.
This topic explains how to set, change, and release database owners, and how to grant or revoke database permissions.
Prerequisites
Before you begin, ensure that you have:
Registered the users you want to assign as owners with DMS. For registration instructions, see Manage users
Set, change, or release owners
Log on to the DMS console V5.0.
In the top navigation bar, choose Data Assets > Instances. On the Instances page, click the Database List tab.
Filter databases by instance endpoint or name to find the database you want to manage.
Select the database, then perform one of the following operations:
Set owners
Click Set Owner. In the Set Data Owner dialog box, select a user and click OK.
Only registered DMS users appear in the drop-down list.
You can assign up to three owners per database.
Change owners
Click Transfer Ownership. In the Transfer Ownership dialog box, select a user from the Original Owner drop-down list and one or more users from the Target Owner drop-down list, then click OK.
You can select up to three users from the Target Owner drop-down list.
Release owners
Click Release Owner. In the Release Owner dialog box, select one or more users from the Original Owner drop-down list, then click OK.
Grant or revoke permissions
Grant permissions
Click Authorize User.
In the Authorize User dialog box, configure the following parameters and click OK.
Parameter Description Add User The users to grant permissions to. Multiple selections allowed. Permission The permissions to grant. Valid values: Query, Export, Change. Expire Date The validity period of the permissions.
Revoke permissions
Click Recycle Permission. In the Recycle Permission dialog box, configure the following parameters and click OK.
| Parameter | Description |
|---|---|
| Recycler | The users whose permissions to revoke. Select one or more users. Must be existing database owners—selecting a non-owner causes an error. |
| Permission | The permissions to revoke. Valid values: Query, Export, Change. Multiple selections allowed. |
What's next
Export database configuration: On the Database List tab, select one or more databases, then choose More > Export config to download an Excel file. The file includes instance status, environment, database administrator (DBA), and owner information.
Export permission records: On the Database List tab, select one or more databases, then choose More > Export permissions to download an Excel file. The file lists database names, users with permissions, the permissions granted, and who granted them.
Enable metadata access control: On the Database List tab, select one or more databases, then choose More > Access control to enable metadata access control for databases in instances managed in Security Collaboration mode. When enabled, only users with permissions on the database can search for its information. When disabled, all users can search for and access the database or instance. For details, see Enable metadata access control.
Manage resource-level permissions: To manage permissions on resources such as databases, tables, and rows, see Manage permissions.