Configure database security
The Common Data Service uses a role-based security model to secure access to the database. This topic shows you how to create the security artifacts that you need to secure an app. These user roles control runtime access to data and are separate from the Environment roles that govern the Environment Administrators and Environment Makers. For an overview of this security model, see Microsoft Common Data Model, Entities Reference. For an overview of environments, see Environments overview.
It's important to understand what level of access to these entities is needed by users of the app. The Common Data Service supports the create, read, update, and delete (CRUD) permissions on entities.
- Create - Allows a user to create new entries in the entity.
- Read - Allows a user to view and search existing entries in the entity.
- Update - Allows a user to update or edit an existing entry in the entity.
- Delete - Allows a user to delete or remove an existing entry in the entity.
The two most common permissions that are used are read-only and full access. The Common Data Service comes with permissions sets for all its entities at these two permission levels. View permission sets provide read access to the entity. Maintain permission sets provide full access to the entity.
The security model supports any combination of these permissions to be assigned to a user role. Roles combine the permissions granted across the permission sets added to them. In this way, members of a role can access all the data provided to them by the permission sets included in the role. For more information about the Common Data Service security model, see Security model.
To configure the proper access controls for an app, you will need to know what entities it is using. To see the entities an app uses:
- Open the app in PowerApps Studio.
- Click or tap the Content tab.
- Click or tap Data sources. The list of data sources will be displayed in the right pane.
When you create a new entity, you also need to create a new permission set or edit an existing permission set to provide access to its data. When you create an app, we recommend that you also create a permission set that provides access to all the entities needed to run the app. Security is managed in the admin center.
- Open the admin center.
- Click or tap the environment that contains your database.
- Click or tap Security. The User roles and Permission sets tabs are used to configure security on your database.
To enable access to a new app you first need to create a new permission set.
- Click or tap Permission sets.
- Click or tap New permission set to create a permission set.
- Give your permission set a name and a description, and then tap or click Create. Your newly created permission set will now show in the list of permission sets.
- Click or tap the permission set that you created.
- Click or tap the Entities tab. The Entities tab contains a list of all the entities in your database. For each entity used in your app, check the permission that you want to allow.
- Click or tap Save.
After the proper permissions are included in a permission set, you can create a role that can be assigned to users.
- Click or tap User roles.
- Click or tap New role.
- Give the role a name and description, and then click or tap Create. Your newly created role will now appear in the User roles list.
- Click or tap the role that you created.
- Click or tap the Permission sets tab.
- Enter the name of the permission set that you created. A drop-down list appears as you type. Click or tap the permission set to add it to the role. Add all the permission sets that you want for the role.
- Click or tap the Users tab for the role.
- Enter the name or email addresses of the users or groups you want to add. A drop-down list appears as you type. Click or tap the user in the list. Users and groups who will have the role assigned are added to the list.
- Click or tap Save.
The users or groups in this role can now access the data that is granted by any permission set associated with the role. To use the data in your database a user must have a security role and access to a PowerApp that uses the data.
Roles and permission sets can be edited after creation by clicking the edit icon.
To delete a role or permission set, use the delete icon.
Two security roles are provided out of the box:
- Database Owner - The Database owner role is intended for users in an administrative function. The creator of the environment will automatically be added to this role. Users in this role will always have full access to all entities in the database, even as new entities are added. The Database Owner role also provides users the ability to create and edit entity schema in the database. You do not need to add permission sets to this role, only assign users to it.
- Organization User - The Organization User role is the default role assigned to all users. This role is intended to provide all users access to the entities that contain public data. If an app is shared in restricted mode, then entities it uses should be contained within this role. You do not need to assign this role, everyone in your organization already has it. You only need to add the permission sets that you wish to give to your entire organization.