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
------------------------------