Can partition-based user privilege be given? Is partition-based user authorization possible? Can we do partition-based authorization in SQL Server, not table-based?
For example; You define 1 table to consist of 5 partitions. Then we want to define different user privileges for these partitions. Is this possible?