Audit Log

Classic Servoy
1

Version: 6.0.5 - build 1230

I am attempting to create an audit log for our Servoy solution. I followed the wiki instrucitons and created a separate database to hold the log table, then clicked on the ‘Create Log Table’ button. The log table was successfully created.

However, when I click on the ‘Security’ tab for tables in the non-log database, instead of seeing the two standard Servoy groups (Adminsitrators and users), I am presented with a myriad of unknown groups (see image below):

For both the Administrators and users groups, I select the ‘Explicit’ radio button, then check the box labeled ‘Tracking (Insert/Update/Delete)’. However, when I edit records for that table, nothing is being recorded in the log table (it’s always empty).

I have no idea from where the other group names originated, nor do I know how to get rid of them (I viewed the data of the ‘servoy_groups’ table in the Servoy repository, and it shows only the Aministrators and users groups). Any help with this would be appreciated.

Also, I do not understand why edit changes are not being logged and was thinking the ‘groups’ problem may be interferring with the log process, so I am looking for advice here as well.

This is all being done in Servoy Developer.

Thanks in advance!

2

At one point you must have imported some sample solutions which had these extra groups, and they have been added to your Resources (they are not in the repository in Developer, they are in your workspace resources project).

But they are easy to delete: just double click the Resources/User and group security in the Solution Explorer, and you will find a button to remove these extra groups.

Also the tracking for a table will only apply if the user doing insert/update/delete is part of one of the groups that you have selected “Tracking” on.

3

Thanks, Patrick, for the explanation of the spurious group origins and for the instructions on how to delete them. I do import various sample solutions but did not realize users groups were also imported…I will have to watch for this in the future.