RootDBApp / rootdb

Main repository containing all releases.
https://www.rootdb.fr
GNU Affero General Public License v3.0
13 stars 0 forks source link

Support RLS (Row-level security) #7

Open simonaubertbd opened 3 months ago

simonaubertbd commented 3 months ago

Hello,

Correct me if I'm wrong but as now, RootDB does not support RLS which is a common feature for dataviz. It allows, with a unique dashboard, to adress several audiences (usual example : Commercial A can only see his own sale, Commercial A manager can see his team sales).

Best regards,

Simon

spo-ijaz commented 2 months ago

Right now you can create user group, and assign users to one or more groups. And then, at report level, you can restrict his access to a list of user, or a list of user group. But it's not what you want here.

Tough there is also the organization feature, not activated on the production build of the app, where your instance of RootDB can handle different... organizations and each organization contains his own set of Reports. A User can be in one or more Organizations - and we already have user roles like administrator, developer, viewer. So the Organizations could represent your commercial teams for instance.