“The Most Complicated Security They’d Ever Seen”: Modeling Metadata for Maintaining Fine Grained Row-Level Security

Presentation Summary

The Harvard Data Warehouse team has implemented many distinct types of very complex row-level security for its reporting environments: for GL, HR, Grants, and others. Maintenance and metadata reporting needs drove us to create a custom abstract MDM model for row-filtering security that worked across all. This talk will review the history and explain the models built, and how they increased efficiency of security data builds and user metadata reviews of the row filtering rules.