CODEWITHSUNDEEP
sqlsecurityazure-sql-databasesecurity-policy
Vlad
Vlad

Reputation: 21

Is it possible to have a SQL view which doesn't take into account the security policy?

[Azure SQL] I have a table1 and a security policy with filter predicate (users see only their own rows).

Can there be a view1 which will summarize all the table1 info by all the users? I can apply a different security policy on the view for a different audience.

Here is an outline of what I mean

Upvotes: 2

Views: 34

Answers (0)

Related Questions