In some scenarios, like single-database multi-tenant or soft delete ones, you could want to restrict access to your rows based on a value stored in one or more values stored in your columns in example IsDeleted flag or some kind of TenantId column. Since SQL Server 2016 we have a wonderful tool for that called Row Level Security Policy.
Strona głównaBazy danych i XML
Bazy danych i XML 2500 dni, 7 godzin, 5 minut temu 114 pokaż kod licznika zwiń