DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In
sgray128 10/19/2016 8:25:31 AM

Dynamics GP SQL Security

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu
I had the chance to shake hands with Beat Bucher (pronounced: B@) at GPUG Summit 2016 last week, glad to finally make the acquaintance. He's such a faithful contributor to the community.

At any rate, he's posted a SQL Security script on the GPUG user forum this morning and I'll re-blog it here so that it's always available to me. The query will show you the Dynamics users for a company and if the user is using the SQL 'Enforce Password' policy and the 'Expiration' policy. Great auditing tool.

The output looks like this

 

Version: All
Section: SQL Scripts