How Do I use table Permission Property In navision

Business Central/NAV
1

How do i use table permission can you explain and give me the example if you have any links exapmles

2

The TableData permission is used to manage user permissions over data in a table.

The Table permission is used to manage permissions over the design of then table object. Only developers should really be able change table objects (the design and structure tables)

Lewis Rosenberg
IT Manager
Mars Fishcare/Mars Horsecare
D365UG-BC/NAVUG All-Star
Twitter: @RosenbergL
LinkedIn: https://www.linkedin.com/in/rosenbergl

3

Thanks @Lewis_Rosenberg for the reply on table permissions!

1 Like
4

Thank you @Lewis_Rosenberg for your Replay

5

Table Permissions in Dynamics 365 Business Central are used to control access to individual tables in the application. Table permissions are managed on a per-user basis, and can be assigned to specific groups of users or to individual users.

To set up table permissions, follow these steps:

  1. Open the Role Center for the user whose permissions you want to modify.
  2. Click on the “Departments” drop-down and select “Administration.”
  3. Click on the “Application Setup” drop-down and select “Table Permissions.”
  4. Select the table for which you want to set permissions.
  5. Choose the permission set that you want to assign to the user or group of users.
  6. Save the changes.

For example, let’s say you want to restrict access to the Customer table to only a specific group of users. You can create a new permission set for the Customer table, and assign it to the desired user group. To do this, follow these steps:

  1. Open the Role Center for the user group you want to modify.
  2. Click on the “Departments” drop-down and select “Administration.”
  3. Click on the “Application Setup” drop-down and select “Table Permissions.”
  4. Select the “Customer” table.
  5. Click the “New” button to create a new permission set.
  6. In the “Permission Set” window, enter a name for the new permission set.
  7. Check the “Read” box to allow users to view the customer data.
  8. Check the “Modify” box to allow users to modify customer data.
  9. Uncheck the “Insert” and “Delete” boxes to prevent users from creating or deleting customer records.
  10. Click “OK” to save the new permission set.
  11. In the “Table Permissions” window, select the user group you want to assign the new permission set to.
  12. Click “New” to create a new line.
  13. Select the new permission set from the drop-down list.
  14. Click “OK” to save the changes.

Now, the users in the specified user group will only have read and modify access to the Customer table, and will not be able to create or delete customer records.

For more information on table permissions in Business Central, you can refer to the official Microsoft documentation: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/application-setup-table-permissions.