我已经为我的Ms Sql Server数据库创建了安全策略。我试图弄清楚BEFORE和AFTER dml操作之间的区别,以及使用它的原因。我找不到关于这个主题的清晰解释。
CREATE SECURITY POLICY [Security].DealershipsCarsFilter
ADD FILTER PREDICATE [Security].fn_securitypredicate(DealershipId)
ON dbo.[DealershipsCars],
ADD BLOCK PREDICATE [Security].fn_securitypredicate(DealershipId)
ON dbo.[DealershipsCars] AFTER INSERT
WITH (STATE = ON);