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?