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

(0) Share

Report

Posted on by mikepeck

340

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

All responses (2)

Answers (0)

mikepeck 340 on at

Like (0)

Report

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

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

Tim Foster 8,515 on at

Like (0)

Report

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

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