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