All Questions
Tagged with row-level-security azure-sql-database
13 questions
0
votes
1
answer
158
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
2
votes
2
answers
426
views
Azure SQL Query Performance Degradation when Row Level Security is ON
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 ...
- 31
1
vote
1
answer
711
views
Using Row Level Security to protect the table that tracks row level securities
The general setup of my RLS is that I have a table like Orders:
OrderID Customer
1 John
2 Bill
And a table, RowLevelSecurityPermissions, that tracks which principal is allowed to see ...
- 696
0
votes
1
answer
262
views
Azure SQL with Azure Active Directory authentication - use in security function for row-level security
We have a Azure SQL database using Azure AD authentication. This all works fine for both Member and Guest AD users, and with AD Groups.
We need to apply row-level security to some tables, based on:
...
- 381
0
votes
1
answer
789
views
Restricting direct access to Azure sql external data source
I try to created Row-Level-Security in a Azure Synapse ondemand database. The data is stored in Azure Datalake Storage Gen 2. The script is working fine, but members of the restricted user group can ...
- 11
1
vote
1
answer
51
views
DbUpdateConcurrency Exception Thrown for RLS Filtered User on Insert
I am running into an issue where users that are enforced by RLS can do everything except insert new records and they receive a DbUpdateConcurrencyException.
If the user is a part of a group not ...
- 31
1
vote
1
answer
223
views
SQL Server - Row Level security using Cross Apply
I'm developing a filter predicate for Row Level Security in SQL Server/Azure SQL Database.
Application logic related to the visibility coins required that a lot of tables must be read in order to ...
- 147
0
votes
1
answer
355
views
azure sql server row level security with ad users
Is it possible to somehow have Azure SQL Server automatically use ad users (in row level security) without always creating a login, or automatically creating a login for every user of an ad group?
- 45
0
votes
1
answer
115
views
How to maintain a copy of a table in memory in Azure SQL?
I am new to Azure and I need help.
We have a table USERS in Azure SQL on disk. This table is populated by admin team and we use the table data. This table is used for implementation of Row Level ...
- 183
1
vote
0
answers
203
views
Azure SQL DB - Row Level Security using O365 Groups
Is it possible to set Row Level Security in an Azure SQL database using Office 365 Groups?
I have a task table in my database with an "Assigned To" (assignedTo) column. It's a varchar(255) ...
- 21
1
vote
1
answer
281
views
Row Level Security not working as expected
I have a requirement to restrict access to rows belonging to RegionID 1. Not sure how I create predicate function to satisfy this condition in predicate function? I have even tried hard-coding 0 & ...
- 610
2
votes
0
answers
95
views
Filter two users for Row Level Security
I'm going to use Row Level Security in Sql server Management Studio
I need help with how I can assign 2 users where one user can see their own rows which has "purple" in rows, and the other user ...
- 21