The Accounting and Finance community deals with high volumes of sensitive and confidential information. As such, reporting which enables everyone within an organisation to see only the information they are authorised to see is of importance to this community. Leveraging the Row Level Security and the hierarchical path enables the finance team to control that one version of the truth, but limit that version of the truth depending on who logs in.
Key benefits of this are:
Time saving - Maintenance of one set of data
Scale - The model is flexible as more individuals get added to the organisation
Secure - Leverages the current Microsoft infrastructure to maintain security by using the username of the logged in individual
Transparent - One set of data means that those who have the highest level of security can see exactly what everyone sees in the same report
Key uses of this are when reports are produced for the company hierarchy or employee hierarchy:
The files attached provides a walkthrough guide on setting up Row Level Security (RLS) and hierarchy for the Employee hierarchy above to produce the below report: