Component Integration Services users can employ the features of row-level access control because access rules can be bound to columns on proxy tables.
When queries against proxy tables are processed, the access rule is added to the query tree during query normalization, thus making its existence transparent to downstream query processing. Therefore, Component Integration Services users can forward additional predicates to remote servers to restrict the amount of data transferred, according to the expression defined by the access rule.
Component Integration Services can function as a row-level access control hub to the entire enterprise through the use of access rules bound to columns on proxy tables.
