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.  MSSQL - block sysadmin role

    Posted 06/21/23 08:59 AM

    Hi, 

    I tried setting S-GATE Terminate and S-TAP Terminate options on the command ALTER SERVER ROLE.

    On both - session level policy and data security policy.

    While using the script - ALTER SERVER ROLE MEMBER [sysadmin] ADD/DROP LOGIN 'xxx'
    Guardium blocks it without any issues (logs, terminate session and alerts).

    But, While using the GUI - Logins => Properties => Server Roles => mark the sysadmin checkbox and press OK
    Guardium doesn't block anything (logs and alerts on the action but doesn't terminate it).

    How can I make sure that it also blocks the GUI option?

    Thanks for your help.



    ------------------------------
    itay Mor
    ------------------------------


  • 2.  RE: MSSQL - block sysadmin role

    Posted 06/23/23 12:16 AM

    Hi,

    Did you check the same SQL Verb is firing when using GUI based changes in MSSQL Server?

    Please log the case with IBM Support.



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