you do not have permission to read the Change Log Setup tabl

charles.rooscharles.roos Member Posts: 60
If i change data in item card with client licence, i get following error message:

"you do not have permission to read the Change Log Setup table"

with developer licence i don't get the error.

change log is turned off. what's the problem then?

codeunit 423 is runned anyway and i see that "ChangeLogSetup.GET" is called:

GetTableTriggerMask(TableNumber : Integer) : Integer
IF TableNumber = DATABASE::"Change Log Entry" THEN
  EXIT(0);

IF COMPANYNAME = '' THEN
  EXIT(0);

IF TableNumber IN
   [DATABASE::"Change Log Setup",DATABASE::"Change Log Setup (Table)",
    DATABASE::"Change Log Setup (Field)"]
THEN
  EXIT(15);

IF NOT ChangeLogSetupRead THEN BEGIN
  IF ChangeLogSetup.GET THEN;
  ChangeLogSetupRead := TRUE;
END;

IF NOT ChangeLogSetup."Change Log Activated" THEN
  EXIT(0);

IF NOT TempChangeLogSetupTable.GET(TableNumber) THEN BEGIN
  IF NOT ChangeLogSetupTable.GET(TableNumber) THEN BEGIN
    TempChangeLogSetupTable.INIT;
    TempChangeLogSetupTable."Table No." := TableNumber;
  END ELSE
    TempChangeLogSetupTable := ChangeLogSetupTable;
  TempChangeLogSetupTable.INSERT;
END;

ResultMask := 0;
WITH TempChangeLogSetupTable DO BEGIN
  IF "Log Insertion" <> "Log Insertion"::" " THEN
    ResultMask := 1;
  IF "Log Modification" <> "Log Modification"::" " THEN
    ResultMask := ResultMask + 2 + 8; // also rename
  IF "Log Deletion" <> "Log Deletion"::" " THEN
    ResultMask := ResultMask + 4;
END;
EXIT(ResultMask);

Comments

  • MalajloMalajlo Member Posts: 294
    You don't have Change log in customer's license.
    And (that's the point of error) you have at least one record in Change log table.
    Delete records and it should work.
  • DeepDeep Member Posts: 569
    You may try.

    Go to tools>Security>Roles.
    Just add the Table ID with the permissions you want in the concerned role.
    Make a new role if you wish to.
    Assign the role to the user ID from which you want to access.
    Logoff and logon.
    Regards,

    Deep
    India
  • charles.rooscharles.roos Member Posts: 60
    Deep wrote:
    You may try.

    Go to tools>Security>Roles.
    Just add the Table ID with the permissions you want in the concerned role.
    Make a new role if you wish to.
    Assign the role to the user ID from which you want to access.
    Logoff and logon.

    Change log table still have one empty record inside, after deletion problem solved.
    Both fields in that table have "notBlank=No" attribute, which enables "invisible" empty record insertion.
Sign In or Register to comment.