Auditing

[OpenIT Solutions]

Hi,

I need to figure out which users have been logging into our sparx instance over the last 30 days. We are using a shared SQL server on the back end - but all users are connecting using the same credentials - via some active server magic.

So is there an audit option in Sparx that will record user log ins?

Regards,

Jon.

[qwerty]

AFAIK no. When you open a repos EA connects to the DB via native or ODBC connector. That will issue a DB authentication (the common DB user). Then EA checks for security and performs the check against the t_secuser table with the appropriate user you are looking for. Maybe you can write a trigger which logs this access. But I'm not sure whether EA accesses this table in other contexts.

q.