web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Advanced SQL Server op...
Microsoft Dynamics GP (Archived)

Advanced SQL Server options in the User Setup window in Microsoft Dynamics GP

(0) ShareShare
ReportReport
Posted on by mikepeck 356

I am trying to find the table / field where the Advanced SQL Server options in the User Setup window in Microsoft Dynamics GP data is stored.

I want to create an SQL Query that will list the values stored for the 'Enforce Password Policy' and 'Enforce Password Expiration'  so I can demonstrate to our auditors that this option is 'checked' for all users.

*This post is locked for comments

I have the same question (1)
  • Suggested answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at

    You could try...

     

    select name, is_policy_checked,is_expiration_checked

    from sys.sql_logins

    WHERE name in (SELECT USERID FROM DYNAMICS.dbo.SY01400)

     

     

    Tim

  • mikepeck Profile Picture
    mikepeck 356 on at

    Thank you very much for the tip, Tim. It worked perfectly.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans