Dear all

Where can I get this kind of information?
I´m using DB2 V8.1 on AIX 5.1.

Thanks in advance

Fabio Neukirchen

Creration date of what? There are alot of things that can get dreated in DB2.

As far as the last logon, I assume you mean the last time a user connected to the DB. Db2 does not persist anything about users/groups other that privileges to certain objects. You can only get info about currently connected users through snapshots.

Andy

Andy,

User creation date, off course. BTW, thanks for your feedback.

Fabio Neukirchen

Users and Groups are controlled by the OS. They have to be created there. I do not know if AIX tracks when a user was created.

Andy

You could write your own security plugin to track such things, for example.