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…
In Azure SQL database, the same query is completed in 4 seconds when Row Level Security is active, and in 1 second when Row Level Security is disabled. When I compared the execution plans of the queries, I found that…
I'm working on a typical client-server webapp. It is using a system somewhat like GraphQL where the client has some flexibility in specifying what data it needs, without custom API endpoints for every type of data. The server is running…
To my amazement, I noticed that simple text search APIs don't utilize the indexes on tables that are part of an RLS policy.For example, mytable has a policy on it, and I'm using a column called text_vector to search on:…
What I'm trying to do is to have a table that assigns a subscription to a user. All the samples I found so far do this via: (auth.uid() = user_id) However I would like to keep track of reassignments. With…
I am trying to retrieve data from a table, bit it is getting stuck in an infinite recursive loop due to my RLS policies, which look at the same table. I have a table called 'community_members' that links 'community_id' to…
I'd like to create trigger function, without specifying by name the other columns that can't be updated. Example: Create table test(id integer, name text, amount numeric); I'd like to prevent updates of any columns other than amount, but to avoid…
Iam using the row level security in supabase with nest.js, So how can I set runtime variables safely to the DB so that I can be sure that the variables sync with each app user (due to the http request…
I have a Azure Synapse SQL table which contains a list of companies. I have created an access matrix, security predicate and policy to filter data presented based on the user. Create FUNCTION spf.rls_securitypredicate_dimcompany(@Companycode AS nvarchar(50)) RETURNS TABLE WITH SCHEMABINDING…