Before I start something from scratch, I am wondering if anyone has ever coded a viewer for the application logs for security?
i.e. Click on an entry and see the changes made to a record or a record added?
Thoughts? Comments?
Kevin
Before I start something from scratch, I am wondering if anyone has ever coded a viewer for the application logs for security?
i.e. Click on an entry and see the changes made to a record or a record added?
Thoughts? Comments?
Kevin
Kdriscoll, are you referring to ‘coded a viewer’ using scriptcase tools such as grid view or form view? IF yes, then yes build the view (form or grid) for the security tables no different than any other table. You can setup / define search features just as you would with something like a search for employee name -for example. Or search for Order using date range etc.
No… I understand on how to create a grid or a form to view the data in the security log.
What i am talking about is coding for the data inside of the description column…
i.e.
Below is a sample of what it stored in the “Description” of the log.
Depending on the size of the update… Sometime 40 changes… picking out the differences in a change is “challenging”
--> keys <-- group_id : 1||app_name : form_imsi_efax||--> fields <-- priv_access (old) : ||priv_access (new) : Y||priv_insert (old) : ||priv_insert (new) : Y||priv_update (old) : ||priv_update (new) : Y
Kevin