Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Dynamics GP 18.2 Audit...
Finance | Project Operations, Human Resources, ...
Suggested answer

Dynamics GP 18.2 Audit User Security Changes

(0) ShareShare
ReportReport
Posted on by avatarmanz 10

A client of mine uses Dynamics GP 18.2. They have 8 full service users and over 100 self service users.

Recently I noticed a few employees with more security roles assigned than the company would like.

Is there a way for me to audit those User Security changes to see who assigned the roles and when?

I've looked at the Activity Monitor in GP but I don't think it gives me what I need.

Is there a script I can run on SQL Server Management Studio?

I hope I clarified enough. This is my first post on here.

Thanks in advance,

Aaron

Categories:
Microsoft Dynamics GP
  • Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    RE: Dynamics GP 18.2 Audit User Security Changes

    Hi,

    If you are tracking who is successfully opening windows with Activity Tracking, you can view who opened which window and when in the Activity Tracking Inquiry window (Inquiry >> System >> Activity Tracking).

    I do agree with Beat in that Activity Tracking within core GP isn’t a true auditing solution. If a user opens the window but makes no changes, you’ll still see that in Activity Tracking. The 3rd party solutions he’s mentioned are utilized many customers successfully if you’re interested in something that can provide you with more detail.

    I hope this helps!

    Thank you for using Dynamics Communities,

    Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP

  • avatarmanz Profile Picture
    avatarmanz 10 on at
    RE: Dynamics GP 18.2 Audit User Security Changes

    Thanks for the clarification.

    When I open the Activity Tracking window where would I look to see who opened the User Security window?

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Dynamics GP 18.2 Audit User Security Changes

    Hi Aaron,

    You'll only be able to see some changes in GP if the internal activity tracking had been enabled in GP.

    Administration >> Setup >> System >> Activity Tracking

    The activity tracking isn't an audit tool per say, as Microsoft stopped providing the true Audit Trailer package years ago.

    You'd have to resort to a 3rd party product like Rockton Audit Trail, or FastPath Audit & AD Authentication.

    GP Activity tracking might tell you who opened the user security form in GP, but not the changes that were done.. And if every sysadmin is using the 'sa' account to perform user maintenance, then you'll never find out who it was actually.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,276 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,975 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans