CODEWITHSUNDEEP
axaptadynamics-ax-2012x++dynamics-ax-2012-r2
William YK
William YK

Reputation: 1125

Is there a way to grant access to a table without creating security privileges?

I have a custom temporary table that is used for a simple custom dialog form. Users receive an error: You are not authorized to access table ‘TmpAddressEntryPrompt’ (TmpAddressEntryPrompt). Contact your system administrator.

I can resolve it if I create a privilege and add the table under Permissions or if I instead call the form with a custom menu item, and add that menu item to a privilege. This is extra overhead that I don't want to add for a temporary table. I've also discovered AllowCheck = No on the form datasource, but this just checks after the form is open, so it still doesn't have access.

Is there a way to just make the temporary table unrestricted for all??

I call the form like this:

args = new Args();
args.name(formStr(AddressEntryPrompt));
args.record(prompt);

promptForm = classFactory.formRunClass(args);
promptForm.init();
promptForm.run();
promptForm.wait(true);

if (promptForm.closedOk())
{
    return true;
}

Upvotes: 0

Views: 1673

Answers (1)

Matej
Matej

Reputation: 7627

The right way is to add the TmpAddressEntryPrompt table to your form AddressEntryPrompt DataSources (with AllowCreate/AllowEdit).

Little less recommended way is to add this table to the form Permissions - Tables (and set Manual to ManagedMy).

Upvotes: 1

Related Questions