Permission Set Changes for Business Central On-Premises v18 and Higher

Permission Set Changes for Business Central On-Premises v18 and Higher Business Central 2021 release wave 1 (v18) introduced a new model for permissions. In previous versions, permission sets and permissions were defined only as data, which means they're stored in the tables of the application and tenant databases. Permission sets and permissions can now be defined in the AL code.

Permissions as AL objects are now the default model in Business Central. For example, you’ll see these changes if you install the Business Central v18 or v19 demonstration database. If you view the permissions-related tables in the database (For example, Permission Set and Permission), you’ll notice that the tables are virtually empty.

The SUPER user permission set can be applied to users as one workaround. You can read, use, update, and delete all data and all application objects in the scope of your license. It will give full access to all data.

Due to Microsoft changes with Business Central’s permission sets, insightsoftware recommends using Web Services to connect to Business Central.
For more information, see: Create a Multi-Tenant Business Central (Dynamics 365 SQL Server) Data Source and Business Central 16 or Later Jet Reports Extensions.