Finance | Project Operations, Human Resources, ...

Security Policy Box

(0) Share

Report

Posted on by sdcraig

366

On the user setup window, they have several users that do not have the Enforce Password policy box checked. Is there a report or a script the customer can run to see what users do not have the boxes checked or do they just have to go through each user one at a time to verify (they have a lot of users)

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Suggested answer

David Musgrave MVP ... 13,965 Most Valuable Professional on at

Like (0)

Report

RE: Security Policy Box

GP Power Tools shows this information in two places.

There is a query in the Security Analyser window and the SQL Login Maintenance window shows it too, including the number of days to password expiry.

Regards

David
Suggested answer

Derek Albaugh on at

Like (0)

Report

RE: Security Policy Box

There isn't anything in GP that I can find, whether report or even GP table.

Most likely as GP us really just a user interface for the SQL Server which is where the true 'Enforce Password Policy' settings exist for the user/login.

I'm not sure if there's any SQL system table which holds that information. The closest I could find is here:

select

@@SERVERNAME as servername,

name,

IS_SRVROLEMEMBER('sysadmin', name) as SYSADMIN,

type_desc,

create_date,

is_policy_checked,

is_disabled,

password_hash,

PWDCOMPARE(name, password_hash) as UsernameAsPassword

FROM sys.sql_logins

Thanks