A data owner is responsible for the data of a database or table in DMS and controls which users can access it. As the owner, you decide who gets permissions and can participate in security approval workflows.
What a data owner can do
Data owners have two capabilities:
Access control: Grant or revoke permissions on the owned database or table for specific users.
Approval participation: Serve as an approval node in the approval process for functional modules configured on the Security Rules page.
How ownership is assigned
Ownership can be assigned in two ways: by an authorized administrator, or by user request.
Assignment by an administrator
A database administrator (DBA) or the original data owner can designate a new data owner directly.
For database instances running in Security Collaboration mode, right-click the database in the left-side navigation pane and choose one of the following options:
| Operation | Menu path | Effect |
|---|---|---|
| Assign a new owner | Management Owner > Set Owner | Designates the specified user as the data owner |
| Transfer ownership to another user | Management Owner > Transfer Ownership | Transfers all ownership rights to another user |
Request by a user
A user can apply to become the data owner of a database or table through the Apply for permissions workflow. The user becomes the data owner only after the request is approved based on the approval process configured for the database instance.
To request data ownership, see Apply for permissions.
What's next
To configure approval processes that use data owners as approval nodes, see the Security Rules documentation.