Results 1 to 2 of 2

Thread: db2audit

  1. #1
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197

    Red face Unanswered: db2audit

    Hi,

    In one of my environment, I found the permission level has been changed for a particular table for a particular user, I need to identify when and who changed the privilage.

    So by using db2audit can i figure it. Or is there any sysibm, sycat tables gives me these details.

    I also need to know how to configure the db2audit in my environment, Is there any doc which will help me on that.



    thanks !
    Last edited by alwayssathya; 11-22-11 at 00:21.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    all is in the books
    Introduction to the DB2 audit facility
    you can find in catalog the permission given (see ..auth tables) not when.. too late
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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