User 'UserName' is not authorized to insert a record in table 'TableName'. Request denied.Clearing the user's usage data won't help. What i tried (and worked :)) was to delete the user’s .auc file, which solved the problem.
Cannot create a record in TableLabel (TableName). Access Denied: You do not have sufficient authorization to modify data in database.
Search for .auc file at Location : “C:\Documents and Settings\%USERNAME%\Local Settings\Application Data”
The purpose of the object caching file (.auc) is to store a local copy of the AOT objects which have been used by the client, so that in the future they do not need to be re-read from the AOS.
We can also change the table’s (EmplTable, in our case) properties like AosAuthorization and MaxAccessMode, which can solve the issue. But the issue was in production environment and I needed a quick fix.
Links: http://blogs.msdn.com/b/emeadaxsupport/archive/2009/05/07/user-username-is-not-authorized-to-insert-a-record-in-table-tablename-request-denied.aspx
http://www.axaptapedia.com/index.php/Object_caching
Hope it is useful.
