Tag Archives: security

SQL view with security and SmartList details in GP

May 13, 2010 by Victoria Yudin 27 Comments

Robert Cavill from Emeco in Australia has sent me an amazing update to my Security Roles and Tasks in Dynamics GP SQL script that includes SmartList objects. This script was originally written for GP 10.0 and GP 2010, but will also work with GP 2013 and GP 2015. To get the most out of this script […]

Continue reading →
Dynamics GP, GP 10.0, GP 2010, GP Reports code, System/Setup SQL code
, , , , ,

SQL view with security resource details for Dynamics GP

March 20, 2009 by Victoria Yudin 38 Comments

As a corollary to my view showing the Dynamics GP security roles and tasks assigned to users, I have created another view that adds the security resource details. Thank you very much to Tim Foster for pointing me to a newsgroup post by David Musgrave detailing how to populate the SY09400 table in SQL which holds […]

Continue reading →
Dynamics GP, GP 10.0, GP 2010, GP Reports code, GP SQL scripts, System/Setup SQL code
, , , , , ,

SQL view to show security roles and tasks in Dynamics GP

March 12, 2009 by Victoria Yudin 25 Comments

Dynamics GP 10.0 has brought about a drastic change in GP security. Not only is the security pessimistic now, so by default no permissions are granted, but setting up and administering security is quite different from what many of us are used to after working with previous versions of GP for many years. And, of course, reporting on […]

Continue reading →
Crystal Reports, Dynamics GP, GP 10.0, GP 2010, GP Reports code, GP SQL scripts, System/Setup SQL code
, , , , , , ,

Granting access to a new SmartList in Dynamics GP

October 8, 2008 by Victoria Yudin 74 Comments

We have been seeing a lot of questions on granting access to new SmartList Builder SmartLists. Because this is so different from older versions of Dynamics GP, we’ve created a really detailed list to go through it. This may be overkill for some, but it will hopefully cover every needed scenario. (Update: These instructions will work for […]

Continue reading →
Dynamics GP, GP 10.0, GP 2010, SmartList Builder
, , ,