on 06-12-2022 2:16 PM
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
Hi Dave,
I'm afraid the SAP security roles will not (always) give you that information. Security is mostly enforced on functionality (read/write) and data structures within the application software which may or may not correspond to the actual data structures in the database. The granularity of authorizations also differs across the various SAP modules, which all have their own specific authorization objects. I'd say there's no easy or consistent way to query these roles for the information you want from them.
Jurjen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.