Tag Archives: security

SQL view with security and SmartList details in GP

Robert Cavill from Emeco in Australia has sent me an amazing update to my Security Roles and Tasks in GP 10 SQL script that includes SmartList objects. I have tested this script with both GP 10.0 and GP 2010 and for both versions to get the most out of this you will want to populate the […]

Continue reading

SQL view with security resource details for Dynamics GP 10

As a corollary to my view showing the Dynamics GP 10.0 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 […]

Continue reading

SQL view to show security roles and tasks in Dynamics GP 10

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
keys

Granting access to a new SmartList in Dynamics GP

We have been seeing a lot of questions on granting access to new SmartList Builder SmartLists in GP 10.0 and GP 2010. Because this is so different from prior 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. […]

Continue reading

Follow

Get every new post delivered to your Inbox.

Join 1,357 other followers