Row Level Security 3 – In Pictures! November 22, 2012Posted by mwidlake in database design, security.
Tags: security, SQL, system development
I’ve noticed that there has not been a lot of traffic on this series on Row Level Security (data masking) so far – maybe due to how I am presenting the material? So here is a summary to date in picture/diagram format:
This is the flow of logic as to whether Row Level Security is applied to the SQL statement. Usually this is a query and usually it is on a table but the policy can be applied to other DML and also on views and synonyms:
If you have not looked at the previous posts on this topic, more details are in there.