IBM Guardium

IBM Guardium

Join this online user group to communicate across Security product users and IBM experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  OS User as Database User

    Posted 04/17/20 02:33 PM
    This question is based on some scenarios I noticed in my own environment and I want to verify that I understand correctly. When the DB User Name cannot be identified by Guardium (due to missing login packet or otherwise) and an OS User exists does Guardium place OS User in the Database User column and append "(OS USER)"? For example:

    Server IP: 111.111.221.222
    DB User Name: User1
    Database Name: Db0
    OS User: User5

    ServerIP: 111.111.221.222
    DB User Name: User5 (OS USER)
    Database Name:
    OS User: User5

    ------------------------------
    Chase Walkup
    ------------------------------


  • 2.  RE: OS User as Database User

    Posted 04/20/20 01:00 AM

    If you refer to report, it is possible

    Create computed attribute which produces OS User in case DB Username is empty.

    Computed attribute uses MySQL functions where IF condition is available.



    ------------------------------
    Zbigniew (Zibi) Szmigiero
    IBM
    Warsaw
    ------------------------------



  • 3.  RE: OS User as Database User

    Posted 04/22/20 04:12 PM
    Zbigniew,

    Thank you. We do not have any computed attributes defined in our environment but I still see this behavior. My question is if this functionality is expected out of the box.

    ------------------------------
    Chase Walkup
    ------------------------------

    Original Message


  • 4.  RE: OS User as Database User

    Posted 04/24/20 11:29 AM
    Hi Chase,

    Generally speaking, if the DB User can not be identified due to dropped packets it will be logged as a ? and there will be a LOGIN_MISSED exception. If it can not be identified due to a specific protocol problem or defect in the sniffer usually it is blank.

    There are some specific cases where the DB User is populated with the OS User followed by (OS User). One such case is for MSSQL traffic in Guardium v9. Prior to correlating the DB User it will appear as you noted there.

    What exact database and OS are you seeing that for? And what Guardium version?

    Then we can confirm it is expected in that case

    ------------------------------
    AVRAM WALERIUS
    ------------------------------

    Original Message


  • 5.  RE: OS User as Database User

    Posted 04/24/20 11:30 AM
    Hi Chase,

    Sorry if you get this multiple times, seems like its not posting to the forum properly...

    Generally speaking if the DB User is missing due to dropped login packets it will appear as ? and there will be a LOGIN_MISSED exception.
    If it is missing due to a specific protocol problem or defect in the product it is usually blank.

    There are some specific cases where it will be populated as you note with (OS User). One I know of is for MSSQL traffic with Guardium v9.
    In that case before the real DB User is decrypted it will appear as you noted.

    If you're not referring to MSSQL on Guardium v9 - Can you clarify:
    - What DB and OS is this traffic coming from?
    - What is the Guardium version?

    Then we can confirm if its expected.

    Thanks
    Avi

    ------------------------------
    AVRAM WALERIUS
    ------------------------------

    Original Message


  • 6.  RE: OS User as Database User
    Best Answer

    Posted 04/27/20 06:01 AM
    Hi Chase,

    UPDATE!
    I did confirm internally that your understanding is correct.

    For Windows S-TAP, if DB User is missing and OS User is available the DB User will be populated with the OS User followed by (OS_USER) to notify that its not the real DB User.

    Hope that helps

    ------------------------------
    AVRAM WALERIUS
    ------------------------------

    Original Message