Creating a non-GP SQL Table Audit for non-GP Users


The information here describes how to setup Auditor for non-GP SQL tables and non-GP users.


Here are the steps to follow:

  1. Go to Microsoft Dynamics GP | Tools | Setup | Auditor | Audit Groups.
  2. In the Group Maintenance window, enter a Group ID and a Group Description for the non-GP SQL tables
  3. Click the Add Audit button and then add the SQL Table Audit(s).
  4. When in the Auditor SQL Table Maintenance window, verify the User Company Access checkbox is unmarked or grayed out.
  5. When finished setting up the SQL Table Audit, click OK.
  6. In the Group Maintenance window, click Access.
  7. In the Audit Group Access window, verify that the All User checkbox is marked, and then click OK.
  8. In the Group Maintenance window, click Save, and then close out of the window for Auditor to initialize.