414 questions
0
votes
0
answers
17
views
How to apply RLS based on username in Oracle Analytics Server (OAS 2025)?
I have a dataset that contains a username column. I want to filter BI visualizations automatically based on the logged-in user in Oracle Analytics Server (2025).
How can I implement RLS (Row Level ...
0
votes
0
answers
38
views
How to Implement Row-Level Security (RLS) in Power BI with DirectQuery Dataset Embedded via .NET Core
I’m working on embedding a Power BI report that uses a DirectQuery dataset, and I want to implement Row-Level Security (RLS) through my .NET Core backend.
Setup Details:
Report Type: Power BI PBIX ...
- 1
1
vote
0
answers
93
views
Getting permission denied to rls policy in Redshift
I have an employee table which has data for all region and countries. As an admin, I want to enable RLS on this table so that the end user can only view the data he is allowed to. The access ...
- 91
3
votes
0
answers
94
views
How to text-search in PostgreSQL when using RLS?
Over the past week, I’ve been working on implementing text search in a NestJS application using PostgreSQL. The challenge is that the app supports multiple tenants, all sharing the same tables, so we ...
0
votes
0
answers
186
views
Supabase Storage RLS Violation Despite Correct Policy Check?
I'm encountering a persistent RLS violation when trying to upload files to Supabase Storage using the JS client (supabase-js). The goal is to allow only authenticated users listed in a public.admin ...
0
votes
0
answers
107
views
Supabase Auth + RLS: Users Authenticated but Failing to Insert Rows via Web App
I'm using Supabase Auth for user authentication and have a PostgreSQL schema with Row-Level Security enabled. Users are able to log in through my React web app without any issues. However, when they ...
- 13
0
votes
1
answer
197
views
supabase_flutter does not allow anon UPSERT with "new row violates row-level security policy" error even though anon RLS policies seem to be set right
I have a Supabase table named "users" that contains a unique key column (text) named "id_rc1" and another column named "version" (text), among other fields all of which ...
- 225
0
votes
0
answers
48
views
PowerBI row level security integration
RLS in Power BI Causing Blank Data – Need Help Debugging
Issue Summary
Applying Row-Level Security (RLS) in Power BI causes all data to go blank when testing with "View As Role" in Power BI ...
0
votes
0
answers
76
views
Power BI Security Manage Roles Issue
DAX expression used to be:
[Email] = USERPRINCIPALNAME() || [Manageremail] = USERPRINCIPALNAME()
Due to the company's changed name, @xy.com has changed to @zw.com.
People still log in with the xy.com, ...
- 1
1
vote
1
answer
79
views
How do I insert into a table with RLS and get the ID back before I have the record linked to the user?
Using Supabase/Postgres, I have 3 tables. auth.users, public.boards, and public.user_boards.
When a user creates a new board, I need to insert a record into public.boards and return the id so that I ...
- 3,473
0
votes
1
answer
163
views
How do I implement email subscriptions for paginated reports in powerbi service?
I want to figure out the best method to create email subscriptions for those reports for people in different regions and departments
1
vote
0
answers
176
views
Supabase - new row violates row-level security policy
I have created a simple app with vue.js frontend and an express.js backend. It has a login that works properly and in the databse I can see one user and his ID. I have enabled row level security for ...
- 699
0
votes
0
answers
105
views
Row-Level Security in Visual Studio 2022 Tabular Modeling Not Working
I'm adding row-level security to a tabular model using Visual Studio. The data will be processed and stored in Azure and analyzed in Excel. Somehow, I'm not sure how yet, the Azure component means ...
- 110
1
vote
1
answer
332
views
How to properly implement an RLS policy for a many-to-many relationship?
I have a trips table and a users table, along with a trip_user junction table to handle the many-to-many relationship of the trips and users table.
I want to implement an RLS policy that only allows ...
- 13
0
votes
1
answer
55
views
Postgres create policy concurrently
I have a postgres table already has row level security enabled, with policy for role1. I want to create another policy for role2. However, when I run
CREATE POLICY policy_name ON {table} AS PERMISSIVE ...
- 73
3
votes
1
answer
183
views
Postgres Permissions violated by before-insert trigger function
I've got a table with row level permissions enabled. I've got an insert policy for my user, and I've granted permissions for them on specific columns. I added a new column to track the id of whoever ...
- 33
1
vote
1
answer
239
views
Apply RLS to a calculated table
I have the following calculated table :
MyCalculatedTable =
DISTINCT (
SELECTCOLUMNS (
FILTER (
'Dim A',
LEFT('Dim A'[Group],1) = "B" &&
...
user9517769
2
votes
0
answers
295
views
How to Hide Filters Based on Row-Level Security (RLS) in Apache Superset 4.0?
I'm using Apache Superset 4.0 and have implemented Role-Based Access Control (RBAC) and Row-Level Security (RLS) to manage data access for different user roles. However, I want to hide specific ...
- 11
0
votes
1
answer
405
views
How to apply RLS to other dimensions when using the static RLS approach?
I have 4 tables. Sales, Customers, Products, Brand. The data model is a standard star schema design.
There are 3 Customers in the Customers table, for example: Walmart, Starbucks, Kellogs.
Customer's ...
- 9,886
0
votes
2
answers
117
views
Row level security policy not working when checking the same table
I have two users: alice and bob.
I have one organization: contoso.
Alice is member of contoso.
What I want is for alice to be able to add bob as member of contoso since alice is member of contoso. I ...
1
vote
1
answer
115
views
In Azure Data Explorer how do I parametrize metadata to be used in Row Level Security function in a query optimized way
My timeseries table T has the columns: location, sensor_id, timestamp and value. The table has thousands of sensor_id, billions of values per year and about 100 locations. The 100 locations are in 6 ...
- 27
1
vote
1
answer
755
views
How do I use Supabase Realtime database with RLS and a custom JWT?
I am having trouble getting realtime data from my Supabase database when using Row level security (RLS) and a custom JWT.
When getting data from the database normally things work as expected, but when ...
0
votes
1
answer
314
views
Design Row level access in a Azure SQL database
I have a requirement to create new SQL database with close to around 10 tables including all fact and dimention tables. This database stores the data for several users from several partner companies.
...
- 1
0
votes
2
answers
400
views
Snowflake: how to securely share Snowsight worksheets & dashboards for data with row-level security
What would be the best way to enable users to share Snowsight worksheets & dashboards for data with row-level security/row access policies?
It seems like sharing a worksheet would be dangerous ...
- 5,513
2
votes
1
answer
2k
views
Power BI Embedded with Row-Level Security
I want to demonstrate to a client how you can embed a report in a custom web application using Power BI Embedded with row-level security (RLS). The client wants to share a report with users outside ...
- 1,082