Privacy, security & compliance
Row‑level security (RLS) restricts data access at the row level based on user or tenant attributes.
In multi‑tenant SaaS, multiple customers share the same database tables, so without RLS, one tenant could inadvertently see another’s data.
RLS policies are defined in the semantic layer or database and appended to every query.
They reference attributes like tenant ID or user role and filter results accordingly.
Implementing RLS prevents data leaks and helps meet compliance obligations.
The Sisense market study noted that single sign‑on and robust APIs are key integration features for embedded BI; RLS works hand‑in‑hand with these features to deliver secure multi‑tenant analytics.
MageMetrics semi-automatically generates RLS policies as part of its auto‑mapping process and allows overrides for specific use cases.