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

(0) Share

Report

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)

All responses (2)

Answers (0)

Suggested answer

Tim Foster 8,515 on at

Like (0)

Report

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

Was this reply helpful? Yes No
mikepeck 356 on at

Like (0)

Report

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

Was this reply helpful? Yes No