You must have very specific Sgate attach criteria.
Trusted connections from an application should be excluded from Sgate rules.
Blocking is most effective when only privileged users coming in from a tool like DBBeaver, Toad, or SQLPLus are interrogated
------------------------------
David Summers
djsummer@us.ibm.com------------------------------
Original Message:
Sent: Fri March 25, 2022 05:17 AM
From: Murdjoko ...
Subject: MS-SQL Blocking policy issue
have you experiences performance issue when activating the blocking policies?
we found that apps will get very long response than usual after applying the blocking policies. It makes success rate drop below 25% as usual because so many process were dropped after apps receiving time-out.
------------------------------
Murdjoko ...
Original Message:
Sent: Wed October 28, 2020 04:15 AM
From: Zbigniew (Zibi) Szmigiero
Subject: MS-SQL Blocking policy issue
Looks that blocking works :)
You must set correct conditions in policy blocking rules to approve allowed accesses.
------------------------------
Zbigniew (Zibi) Szmigiero
IBM
Międzyrzecz
Original Message:
Sent: Sat October 17, 2020 06:30 AM
From: PHANENDRA RAO CHAVANA
Subject: MS-SQL Blocking policy issue
Hi,
I have created policy in Guaridum for MS-SQL server to block the select or drop command, but while connect database itself, unable to login because many queries running in background while connecting, how can I overcome it?
Error while login to database(created blocking policy for select &drop commands):
Thanks,
Panendar Rao.C
------------------------------
PHANENDRA RAO CHAVANA
------------------------------