Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2007
    Posts
    2

    Question Unanswered: Creation date and last logon date

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    Feb 2007
    Posts
    2
    Andy,

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

    Fabio Neukirchen

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You could write your own security plugin to track such things, for example.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •