2 Replies Latest reply on Jul 28, 2017 8:45 AM by Mark Cederholm

    Logging User Changes

    Mark Cederholm

      As part of SOX compliance requirements, we need to log when ArcFM/Designer users are added or removed or change roles.  I thought I could solve the problem by adding some simple Oracle triggers to the mm_px_user and mm_px_user_role tables.  When I try that, however, Px Admin login fails with the message:

       

      The user does not have Write permissions to access table MM_PX_USER_ROLE.

       

      Provider Message: Operation is not allowed in this context.

       

      If I drop the triggers, Px Admin works again. Any ideas?