Results 1 to 5 of 5

Thread: Secure DB2

  1. #1
    Join Date
    Mar 2013
    Posts
    2

    Unanswered: Secure DB2

    Hi Everyone,

    We have IBM TDI and TDS installed on windows servers, and we have problems with the security of the DB2 database.

    Everyone who can logon to the windows server, can change the "root" password without knowing the old password.

    Is there a a solution to fix this problem?

    Greetz Richard,

  2. #2
    Join Date
    Jul 2011
    Location
    USA
    Posts
    80
    user creation/maintainance in db2 invironment is always at OS level, there is nothing to be done from db2 side. So Please check with OS team with userid and you can ask for required changes.

  3. #3
    Join Date
    Mar 2013
    Posts
    2
    Can you than tell me if you can log all the changes to de DB2 database? This will help a us a lot.

  4. #4
    Join Date
    Jul 2011
    Location
    USA
    Posts
    80
    db2 diagnostic log can provide you so much information, list history command and db_history table is also there through which you can get many information in a formated way.

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Richardvd View Post
    Can you than tell me if you can log all the changes to de DB2 database?
    I guess you might be looking for something like this: Introduction to the DB2 audit facility - IBM DB2 9.7 for Linux, UNIX, and Windows
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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