Why are objects missing from the Security Resource Descriptions (SY09400) table?

David Meego - Click for blog homepageIf you want to do any reporting on Microsoft Dynamics GP application level security from the SQL Server level, you need to use the Security Resource Descriptions (SY09400) table to map the Resources Type, Dictionary ID and Security/Resource ID to actual named resources that make sense to humans.

I have often seen questions raised about why some systems have all the resources listed in this table and other systems only have a subset of the resources or the table is empty.

Continue reading

PSA: Everything you want to know about the WannaCry ransomware

David Meego - Click for blog homepageCybersecurity is back in the news this week.

The WannaCry ransomware or crypto-virus has infected many computers around the world and highlighted that the threat of scams, viruses, trojans, worms and ransomware is very real and that you need to be forever vigilant to keep your systems and your data safe.

In this article I want to remind everyone of some easy and simple ways to keep yourself safe.

Continue reading

#GPPT What’s New: Security Activity Tracking and Security Log

David Meego - Click for blog homepageAs GP Power Tools approaches release, it is time to continue the What’s New series and explain another of the new features added to the product.

You can now enable Security Activity Tracking to collect statistical data on the usage of the various resources and security objects within the system.

Continue reading