To manage scenarios when row-level security (RLS) limit is exceeded,
Consolidate Rules Using Comma-Separated Values - Combine multiple access permissions into a single rule by listing values as comma-separated entries within a field. This approach reduces the total number of rules per user.
Implement Group-Based Access Controls - Organize users into groups based on their access requirements and define RLS rules at the group level. This method decreases the number of individual rules per user. Ensure that group assignments align with the desired data access patterns.
Utilize Tag-Based RLS for Anonymous Users - For embedded dashboards accessed by anonymous users, apply tag-based RLS to control data visibility. This technique involves assigning tags to dataset columns and specifying tag values at runtime, thereby managing access without exceeding the rule limit.
By adopting these strategies, you can effectively manage and mitigate the constraints imposed by the 999 RLS rules-per-user limit.
Hope this helps!