Skip to Content
0
Jun 12, 2022 at 01:16 PM

Replicate SAP Row Level Security on SQL Server

365 Views Last edit Jun 30, 2022 at 10:57 AM 2 rev

Hi,

Firstly apologies I have no real experience in SAP, I am a Lead Data Engineer working on SQL Server and Azure.

We are currently in the process of creating a data feed between SAP and our Azure Data Lake using OpenHub to extract the SAP data. As the information is sensitive the Data Lake is locked down so only specific developers can access the data. Upstream from this we will be moving the data to our SQL Server Data Warehouse which is where we need to enforce a strict security layer. As I understand it the SAP security which restricts what someone can see is based on their role, Is there a way to replicate this on a SQL database? Just as an idea, if we had details on SQL Server of each Role, what row level security the role enforced and who was in each role we could use SQL Server row level security to enforce this. Is this possible or is there a better approach?

Many Thanks