Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
To perform an action on a row, a user needs to have the required privilege assigned through a security role or the user must be a member of a team that has a security role with assigned privileges.
To perform actions on a row, the system checks your privileges and if the privilege check passes, then the system performs an access check. The access check verifies that you have the required rights to perform actions on a row such as read, write, create, delete, append, append to, share, and assign.
You can have access rights to perform an action on a row through ownership, role access, shared access, or hierarchy access.
Access type | Description |
---|---|
Ownership | User owns the row or belongs to a team that owns the row. |
Role access | User has access to perform an action on a row because of their security role. |
Shared access | The row is shared with a user, team, or organization by a user that has appropriate share rights. |
Hierarchy access | Hierarchy access only takes place if hierarchy security management is turned on for the organization and the table. The user also needs to be a manager. |
For more information on how privileges and access checks work, go to How access to a row is determined.
Select a row.
Select Check Access on the command bar.
The Check Access window displays your access information.
Contact your administrator if you don't have the required access. Only an administrator can edit your security role and privileges. To find your administrator, go to Find your administrator or support person.
If you're an administrator, you can check the access another user has to a row.
The admin, owner of the record, or users who have access to a row can share the row with other users for collaboration.
To see who has access to a row and their respective access level, complete the following steps.
Note
There are two database settings for each environment that enable the Who has access feature. System adminstrators can Install the OrganizationSettingsEditor tool and set the following options to true:
Select a row.
Select Check Access on the command bar.
In the Check Access window, select Who has access.
Note
The manager list from heirarchy and position security is not shown under Who has access as this list can be long.
If you select a user who doesn't have access to the record, the page returns with a blank screen.
The user's record privileges are displayed. You can tab to each of these privileges to see who has this privilege on the record.
A user can have access to a record through one or more of these categories.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayTraining
Module
Get started with security roles in Microsoft Dataverse - Training
Learn how you can set permissions to limit access to an environment, or limit which users can view, edit, or delete data in an environment within Dataverse.
Certification
Microsoft Office Specialist: Access (Office 2016) - Certifications
Demonstrate that you have the skills needed to get the most out of Access 2016 by earning a Microsoft Office Specialist (MOS) certification.