Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Add a default role for row level security

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.
Status: Needs Votes
Comments
nishalit
New Member
This role would be applied if none of the other roles were applied. This would have two advantages.

1. If an email address or security group was missing from a role, then the default (potentially more restrictive) role would be applied, rather than displaying all data. (Which strikes me as a big security flaw in the current implementation).

2. Would allow row level security to be applied using functions like UserPrincipalName() without having to name everyone with access to the report in a role.
matthias_mann
New Member
As it is now RLS is basically useless for managing larger numbers of report consumers. Manually adding every role is simply unreasonable and hard to manage in the long run.
fbcideas_migusr
New Member
Status changed to: Needs Votes