Questions tagged [row-level-security]
Row-level security is database security term which relates to the ability to define and enforce access control logic on rows of data such that a user can only retrieve the rows of data they are allowed to view.
row-level-security
404
questions
0
votes
0
answers
26
views
RLS not working correctly with Google oAuth / supabase
With nextjs I have a google OAuth login with supabase and I want to have specific users to be able to insert, update, delete files. So I've given certain users the role 'service_role' and have added ...
1
vote
0
answers
42
views
Row-level security with session_context doesn't work after refreshing token
I have a multi-tenant database, I use Row-level security to filter/block data for every table. Every time someone queries the table, they need to set up the session context. I have a API set up where ...
- 1,251
0
votes
1
answer
104
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,205
-1
votes
0
answers
31
views
Who manages logins the API or the front end web app [duplicate]
I'm working in a team where I'm developing an ASP.NET Core 8.0 Web API for a multi tenant application that returns results from a SQL Server database, and someone else is developing a web portal that ...
- 1,251
0
votes
1
answer
68
views
Postgres with row level security does not optimize queries / uses one-time filters
It seems that postgres with enabled row level security on a table cannot properly optimize queries. The following example sql demonstrates the issue:
begin transaction;
-- create demo table
...
- 747
0
votes
2
answers
47
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 ...
0
votes
0
answers
31
views
User cannot query Bigtable with BigQuery Filtered Data Viewer permissions
I have a dataset in bigquery that has row level access policies that restrict access based on an account id. In order to link a user to an account ID, I add a specific row level access policy.
The ...
- 1
0
votes
0
answers
24
views
Need a PostgreSQL RLS policy for employees to see posts
I am using Supabase and PostgreSQL and have a number of tables as below:
Table 1: user_roles:: id, created_at, user_id, role_id
Table 2: roles:: id, created_at, role_name
id 1 >> admin
id 2 >...
- 139
1
vote
0
answers
50
views
How to assign a default security row for RLS in Power BI workspaces?
I have a power BI dataset that I'm looking to give access to a large population of the company. I don't want to have to go through and assign every person to a security role through the GUI. Is there ...
0
votes
1
answer
51
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 ...
- 17
1
vote
0
answers
10
views
Exporting Power BI Row-Level Security Details by Workspace
Is there a way to export the RLS configured on semantic models by workspace?
I only found this tutorial : https://www.fourmoo.com/2022/06/22/how-to-get-power-bi-row-level-security-rls-role-users-...
- 10.2k
0
votes
0
answers
21
views
PowerBI: Row Level Security with not all users in Table
I have a question regarding RLS. I have a table which I want to use the RLS on for an APP in Power BI and I do not want to create more than 1 role but instead have 1 Role manage all users. The issue ...
0
votes
1
answer
170
views
Row-level security in SQL server
In this scenario, I seek assistance in implementing row-level permissions for a table named 'user' with columns 'username' and 'role'. The objective is to establish a security model where access to ...
0
votes
0
answers
128
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 ...
1
vote
0
answers
67
views
Row level security on select statement to select multiple rows from two tables
I have only used Postgres briefly, so still trying to learn.
I have 3 tables, "users", "teams" and then to connect users to multiple teams "users_teams".
users
...
