I know there has been many disscusions on Servoy security and custom security integration.
I currently use custom security, I also want to be able to use the logging feature to track changes made within tables and who made them.
I have a Current_User_ID global field I use for my custom security, is there anyway to enable logging for the solution while I use my own custom security?
Thanks,
Erich
The logging is based on the “Tracking” checkbox on the tables access for a particular login group. IF you use the Servoy security to have the user login (so we can get the group - and thus the “tracking” setting) - then yes. You can then “read” that username (and group) and do your own security enforcement.
If you’re just putting up your own dialog - and bypassing the Servoy security - then no. You have to do the tracking yourself.
I have a users table that has the username, User_ID and password and a bunch of other information. I have a global User_ID (that I capture at log in by the password/username relationship to the user table).
I use this throughout the solution to Identifiy the current user, send emails, track transactions, etc..
If I was to set up users in the built in security, and the password/username matched the one in my User Table could I somehow populate my global User_ID field with the ID from my user table during log_in??
It would not be to bad to keep the password/usernames synched between My user table and the built in security, since they will not be added on a routine basis.
This would add a new dimension to my solution and allow me to intergrate my security.