Exercise – Set authorization requirements on database tables

  • 15 minutes

Scenario

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.