Set up security permissions for a column

There are two steps to set up security permissions for a column.

  1. Enable column security on one or more columns for a given table.

  2. Associate one more existing security profiles, or create one or more new security profiles to grant the appropriate access to specific users or teams.

After you create the profile, you assign users and or teams to that profile, and set up specific read, create, or write permissions for the column.

More information: Security concepts

Note

The use of table-related terminology depends on the protocol or class library used. See Terminology use depending on protocol or technology.

Enable column security

  1. Sign in to Power Apps.

  2. Select Dataverse > Tables.

  3. Select a table.

    Select the Contact table.

  4. Under Schema, select Columns.

    Under Schema, select Columns.

  5. In the Columns list, select a column.

    Select the Mobile Phone column.

  6. Expand Advanced options, and then under General, enable Enable column security.

    Expand Advanced options and enable column security.

  7. Select Save.

Associate security profiles and set permissions

  1. Sign in to the Power Platform admin center with System Administrator security role or equivalent permissions.

  2. Select the environment to configure security profiles for.

  3. Select Settings > Users + permissions > Column security profiles.

  4. Select an existing profile, or select New Profile, enter a name, enter a description, and then select Save.

  5. Select the Users tab, select + Add Users, select the users that you want to control access, and then select Add.

    Tip

    Instead of adding each user, create one or more teams that include all users that you want to control access.

  6. Select the Column Permission tab, in the Name column select one or more columns, and then select Edit. Configure the three columns for the desired access.

    Edit column security permissions.

  7. Select Save.

Any users not defined in the previously created column security profiles won't have access to the mobile phone column on contact forms or views. The column value displays Lock icon. ********, indicating that the column is secured.

See also

Column-level security to control access
Enable or disable security for a column to control access