Hi All,
The code below cannot be published from VSCode to the brand new BC 18.0.23012 online sandbox:
codeunit 50100 XXXInstall
{
Subtype = Install;
trigger OnInstallAppPerCompany()
var
XXTest: Record XXXTest;
begin
if XXXTest.FindFirst() then;
end;
}
the error is
'You do not have the following permissions on TableData XXXTest: Read. To view details about your permissions, see the Effective Permissions page. To report a problem, refer to the following server session ID: '11111'.' and AL stack trace: XXXInstall(CodeUnit 50100).OnInstallAppPerCompany line 4 - xxx by SalesPad ""Extension Triggers""(CodeUnit 2000000010).OnInstallAppPerCompany line 2
Modify() gives similar error.
I have moved XXXTest table from 70M to 50K range, this did not help. If I disable the trigger and install the extension, then I can read and modify data. There is just one user account in this database which is SUPER. Here is the sample table object I'm testing at the moment:
table 50100 XXXTest
{
Caption = 'XXXTest';
fields
{
field(1; XXXKey; Code[20])
{
Caption = 'Key';
DataClassification = CustomerContent;
}
}
keys
{
key(PK; XXXKey)
{
Clustered = true;
}
}
}
I can use OnInstallAppPerCompany() to read and modify tabledata in standard MS tables (not in the extension being installed).
The trigger works fine in sandboxes with BC 17.5 and lower.
Please share if you have any ide what could be wrong.