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
Back to discussions
Expand all | Collapse all

Blocking DDL command issue with MSSQL management studio

  • 1.  Blocking DDL command issue with MSSQL management studio

    Posted Wed December 16, 2020 03:57 AM
    HI everyone,

    I have an issue in blocking one DDL command(drop) from Guardium. Am able to block the drop command for MSSQL server connecting through SQL Server Management Studio and once the session gets terminated, when the user tries to execute that command again for twice or thrice, dba is able to reconnect the same session and drop command is able to execute and again it is blocking the command.
    Ultimately policy is working fine but even dba is able to execute drop command in between some time.
    Please suggest solution for this, its very important.

    Thanks,
    Panendar Rao.C

    ------------------------------
    PHANENDRA RAO CHAVANA
    ------------------------------


  • 2.  RE: Blocking DDL command issue with MSSQL management studio

    Posted Thu December 17, 2020 06:02 PM

    Hi Phanendra, 

    Kindly check if you are using open or closed mode. This issue may occur in open mode and this sounds like a known issue on SSMS client. 

    Refer the below link for more details and possible resolution - 

    https://www.ibm.com/support/pages/guardium-s-gate-terminating-every-other-query-microsoft-sql-server-management-studio

    Regards, 

    Aniket Vekhande



    ------------------------------
    Aniket Vekhande
    ------------------------------

    Original Message


Related Content