Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-20862

Re-enable triggers when the ACL optimizations are reactivated on PostgreSQL/SQL Server

    XMLWordPrintable

    Details

      Description

      When the ACL optimization is disabled, 3 triggers are also disabled with this code:

      #IF: ! aclOptimizationsEnabled
ALTER TABLE acls DISABLE TRIGGER nx_trig_acls_modified;

#IF: ! aclOptimizationsEnabled
ALTER TABLE hierarchy DISABLE TRIGGER nx_trig_hierarchy_modified;

#IF: ! aclOptimizationsEnabled
ALTER TABLE aclr DISABLE TRIGGER nx_trig_aclr_modified;

      but when the optimization is enabled, nothing enables the triggers.

      Therefore all the newly created documents cannot be found for normal users, when the ACL optimization is on.

      Note that a similar problem is present on SQL Server.

        Attachments

          Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. NXP-19377 Fix re-enabling of acl optimizations after they have been disabled

          • Major - Major loss of function.
          • Resolved
          is related to

          Bug - A problem which impairs or prevents the functions of the product. NXP-27913 Re-enable triggers when the ACL optimizations are reactivated on Oracle

          • Major - Major loss of function.
          • Resolved

          Task - A task that needs to be done. NXDOC-1053 add post HF installation steps for NXP-20862

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours
                  2h