Is it possible to apply row level security on a SQL View ? thanks
The topic Row -Level Security includes this passage:
Indexed views: In general, security policies can be created on top of views, and views can be created on top of tables that are bound by security policies. However, indexed views cannot be created on top of tables that have a security policy, because row lookups via the index would bypass the policy.
There is also:
Partitioned Views: Block predicates cannot be defined on partitioned views, and partitioned views cannot be created on top of tables that use block predicates. Filter predicates are compatible with partitioned views.
Which is sort of interesting, since a partitioned view is simply a view that fulfils certain condition.
22 people are following this question.