Lab – Set authorization requirements on database tables


Read this first - before you start the lab!


For this lab, you CANNOT sign in with your own credentials. Use the following steps to sign in to your lab environment with the correct credentials.

  1. Ensure that you are signed in to Microsoft Learn.

  2. Select Launch VM mode or Sign in to launch VM mode in this unit.

  3. In the Resources tab on the lab side bar, select the T icon next to Password in the MININT box, to have the administrator password for the Virtual Machine entered for you.

    Screenshot of the administrator password.

  4. Select Enter.

  5. Microsoft Edge will open. Wait for it to navigate to the Sign in page for finance and operations.

  6. On the Microsoft Sign in page in finance and operations, place your mouse cursor into the Username field.

  7. On the Resources tab of the lab side bar, below the Azure portal heading, select the T icon next to Username, then press Enter.

    Screenshot of the Username field and the Sign in dialog box that appears.

  8. Your mouse cursor will now be in the Password page.

  9. On the Resources tab of the lab side bar, below the Azure portal heading, select the T icon next to select Password, then press Enter.

    Screenshot of the Password field the Enter password dialog box that appears.

  10. Don't stay signed in or store the password on the virtual machine.

  11. Select Accept in the Permissions requested page.

    Screenshot of the Permissions requested page.

  12. To see the lab instructions, select the Instructions tab on the lab side bar.

You can now begin your work on this lab.


You want to enable the Table Permissions Framework for a specific table in the Application Object Tree (AOT).

Enable the AOSAuthorization property

  1. Minimize the Microsoft Edge window.
  2. Select Run as administrator to open Visual Studio.
  3. Select Yes in the Do you want to allow this app to make changes to your device? window.
  4. Select Continue without code.
  5. Start creating a new project by opening the File menu and selecting New > Project.
  6. In the Create a new project dialog box, ensure that Finance Operations is selected in the Recent project templates section, and then select Next.
  7. In the Configure your new project dialog box, enter FleetManagementClassProject in the Project name field.
  8. Select Create.
  9. To ensure the correct settings are in place, select Dynamics 365 in the Extensions menu.
  10. Select Options.
  11. Under the Dynamics 365 node on the left pane, select Projects.
  12. Ensure the check boxes are selected for Organize projects by element type and Synchronize database on build for newly created project.
  13. Select OK.
  14. Right-click your project in the Solution Explorer.
  15. Select Add > New item.
  16. Under Dynamics 365 Items on the left pane, select Data Model, and then select Table.
  17. Name the table MyTable.
  18. Select Add.
  19. With MyTable open in the designer, right-click the main node of the table and select Properties.
  20. In the Properties window, find the AOS Authorization property. This property is set to None by default.
  21. Select the drop-down icon in the AOS Authorization property, where you will see six options:
    • None
    • CreateDelete
    • UpdateDelete
    • CreateUpdateDelete
    • CreateReadUpdateDelete
    • Read
  22. Select CreateReadUpdateDelete.
  23. Select Save MyTable.

Close the lab environment

  1. Select Done in the Instructions pane in the lab side bar.
  2. In the Lab is complete window, select Continue, and then select Leave to return to the next unit in the module.