Forum Discussion
Creating and Parameterizing Roles with more scalability?
allan_vxcase yes, you are making it super complicated for yourself. You can have a table with the Manager Id, Manger Email (used to access Power BI reports), and Store ID they have access to. You will add one role, where you will compare which user is currently logged in and filter these stores they have access to. Check this article for more details
Alright. There's my current 'Manage roles' window.
I must create dozens of rows corresponding to each sales manager of my company's physical stores. I need this because every sales manager needs to access only their stores's commercial data. To achieve that, I setup a RLS parameter to filter the tables according to the row. This number is the id of the manager.
Finally, what I'm trying to do is to set up every manager's role with their names for each role, and then have each role pointing to their corresponding id in a specific table (the one that's selected in the picture).
Is there a way for me to set up them automatically, granting each 'role name' and each parameter in a csv or something like that?