Have you enabled FIREWALL on STAP (probably yes if user based scenario works)?
What firewall mode do you set - Open or Close?
How do you refer to your table in query versus blocking policy object reference?
I suggest use the group of objects with definitions: CardholderData and %.CardholderData to avoid incompletness of blockinf scenario is your table is referred with short name or using FQDN.
------------------------------
Zbigniew (Zibi) Szmigiero
IBM
Międzyrzecz
------------------------------
Original Message:
Sent: Sun August 17, 2025 08:59 AM
From: mohamed saleh
Subject: S-GATE TERMINATE not firing on specific table access
Use case:
Allow the database user GUARD to log in and run queries normally.
Block the user immediately if they try to access the table dbo.CardholderData.
What we tested:
Created an access policy with Object = dbo.CardholderData and Action = S-TAP-TERMINATE.
Result: Policy did not block the query.
And we try with s-gate attach and s-gate terminate
Result: Policy did not block the query.
As a test, we changed the rule to block the user at login with s-gate attach and s-gate terminate , and it worked fine (session was blocked immediately).
so how i can block the user when he access specific table ?
------------------------------
mohamed saleh
------------------------------