User Security Audir export

  • 29 August 2018
  • 1 reply
  • 10 views

As a follow-up to our last meeting, I use the attached SQL query to gather the data dump for Auditors. It takes about 2 mins to run on the server, but outputs the screens that each user has access to. I have a flag in the WHERE clause that I filter out the Inactive users, which you can remove or alter for the opposite.





------------------------------
Patrick Freeman
ERP Manager
Chromalloy Gas Turbine Corp
Orlando FL
321-947-4700
------------------------------

1 reply

This is awesome!  Thank you very much, this will come in very handy.

------------------------------
Theresa Goering
Applications Manager
Tecomet
Lansing MI
------------------------------

Reply