Jon Jowsey on 17 Aug 2016 07:46:21
I want to be able to assign all users (including new ones) to a default role in RLS. Currently I have to assign each user to the role manually, and update the roles manually when users change.
This limits the ability to use RLS with a larger user base.
- Comments (25)
RE: Add a default role for row level security
Agree - if we could have some role defined for those who are not assigned to a role this would be good.
For the time being I'm using a corporate GMS group to add everyone.
RE: Add a default role for row level security
Would very much like to see this appear in the near future - with a growing amount of users accessing Power BI, the ability to assign a default role that restricts visible data would be incredibly useful.
RE: Add a default role for row level security
Totally agree - we need the ability to assign a "Default" role to all users. This would add incredible power to RLS so that you are only assigning a different role if needed, rather than for EVERY user.
RE: Add a default role for row level security
Any updates on this? I need this function very much for a group a couple of hundred people all over the world, changing everyday!
RE: Add a default role for row level security
I just realised Other User allows you to check against a specific users email. Bugger.
RE: Add a default role for row level security
It is interesting that when you click 'View as roles' there is a 'None' and an 'Other user'.
Other user' is defined nowhere and we don't have the ability to set the rules on it... so why have it? Maybe they are preparing for this feature and allow us to set a rule against 'Other User' that is defined to anyone that has accessed but not yet given a role.
RE: Add a default role for row level security
Agree to that it is a simple but very helpful feature. Having to add user to a RLS is very cumbersome
RE: Add a default role for row level security
It would also help when trying to give minimal access by default. If no roles were passed, the default role could block most, if not all, data. This would allow you to create reports that require a role in order to see any data instead of the lack of a role showing all data.
RE: Add a default role for row level security
If the 'Manage Roles' dialog had a 'default' option to set table filters for users who had no role assigned, the problem would be solved from my point of view.
RE: Add a default role for row level security
I would very much appreciate this functionality as well. If you have a large userbase that is changing frequently you really need a default role!