You Do Not Have Permission To Modify/Read/Execute/Insert Records in the….


You Do Not Have Permission To Modify/Read/Execute/Insert Records in the….

This is the most common error message that a user will face and also one of the easiest to figure out…with the right know how! 

-You do not have the permission to insert records into…
-You do not have the permission to modify record in the…
-You do not have the permission to execute…
-You do not have the permission to read…
To find out which permissions need to be assigned to a user for a specific error message you can do the following: 
1. Read the error message! – This error message is referring to the ‘General Ledger Setup’ table and the permission to ‘Modify’ the records within it. 
2. You must log into the Database as a super user/ or a user with the permission to the object designer.
3. Open the Object Designer via >> Tools >> Object Designer.
4. Select the ‘Table’ option and use the Find function (Ctrl-F) to search for the ‘General Ledger Setup’ table -. (or whichever table is causing the issue).

5. As you can see from the above screenshot the table in question is No. ’98’.
6. Navigate to the Permission table – this is 2000000005 – (or search for Permission). >> Then run this table (Ctrl-R) or just hit the ‘Run’ button.
7. Once the Permission table is open you can then filter the ‘Object ID’ column for the relevant Table ID. In this case ’98’. To filter you can use the filter button or press F7.
8. Once this is filtered you will see a list of ‘Roles’ which relate to the Object in question. As you can see below we are looking for a Role with the modify permission. You would need to select the most appropriate for the user ie. If they worked with Jobs – we would use the ‘JOB-JOBS, EDIT’ permission.

Note: You can clear all the filters and then for example, filter by the Role ID – ‘JOB-JOBS, EDIT’ this would give you a clear indication of what other permissions this would give to a user. 

9. Assign the relevant role to the User and then synchronize the logins (see my other post on Synchronizing logins). This should then resolve the issue for the user. 
In another post I will cover how to make your own permissions so you can start tailoring roles to certain users. 

The following two tabs change content below.

Andy, Software Engineer

Andy is Software Engineer at Metaphorix