security - SQL Server : throw exception if a row with column value is accessed -
in sql server 2014 , 2016, there way throw exception if row particular column value accessed?
i accessed instead of returned because row participate in aggregation , not included in end result, when doing count of rows.
for example, have row columns values:
container: 'a' column1: 1 column2: 2 column3: 3
i want select column1 tbl
throw exception, because access row container = "a"
.
select column1 tbl container <> 'a'
should not throw exception.
this different row level security in row level security silently filter out rows whereas want sql server throw exception.
Comments
Post a Comment