Fixing "You do not have the following permissions on TableData (table): (permission)" in Business Central AL

Grant the missing table permission

1. 1Note the exact table name and permission letter (Insert, Modify, Delete, Read/View, Execute) reported in the error.
2. 2Open the Permission Sets page and check which sets are assigned to the affected user, either directly or through a User Group.
3. 3If the table belongs to a custom AL extension, open or create a PermissionSet object in that extension's source, and add a TableData permission line for the table with the required access letters.
4. 4Republish the extension so the updated permission set is deployed, then reassign or re-verify the permission set on the affected user or user group.
5. 5If the table is a standard Business Central table, edit an existing custom permission set (do not modify built-in sets) to add the TableData line instead.
6. 6Use the Effective Permissions page for the user to confirm the final combined permission after all assigned sets, since another set can still be denying or simply not granting the right.
7. 7Have the affected user sign out and back in, or start a new session, since permission changes are not always picked up mid-session.
8. 8Test with a non-administrator account before go-live; SUPER or admin accounts will not reproduce this error even if a real user's permission set is missing the grant.

Defining a permission set in AL

permissionset 50100 "My Ext - User"

{

    Assignable = true;

    Permissions = tabledata "My Table" = RIMD;

}

Common pitfalls

• !Testing only with SUPER or administrator accounts, which never surface missing permissions during development.
• !Editing a built-in Business Central permission set instead of creating or extending a custom one.
• !Granting a permission set but forgetting to assign it to the specific user or their user group.
• !Renumbering or renaming AL objects, which can silently break existing TableData permission references tied to the old object.
• !Assuming a permission change takes effect immediately without a fresh sign-in or session.