on 06-19-2017 12:01 AM
bi-platform-report-user-security.jpg
Hi Team ,
I was looking into BI platform tool-> Landscape Tools->Security Analyzer -> Select Report Vs User security, we are getting the results in the right pane.
We are trying to achieve similar functionality through SDK and in the process of deriving SQL query which gives the "List of reports a user has access to in the entire repository (public and user's private folders) " . I assume that the template would be like " Select si_id,si_name ,xxxx ,yyy,zzz from CI_Infoobjects where userid ='testuser1' and right id = '3' and right status = 'Granted'.
Can someone help with the correct SQL used in the background to derive results as shown in the attached screen shot from promotion management tool.
Hi Joe,
Thank you for referring me to the link : https://archive.sap.com/discussions/thread/1454103 . I could get the list of reports a user has access to using Select TOP 10 SI_ID, SI_NAME, SI_CUID, SI_KIND From CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS WHere SI_KIND='webi' And IsAllowed(1250620, 3) . But this is getting me results only from "public folders" and note getting the list of reports from private/favorites folders. Do you have any suggestion to include favorites in the search/result set ?
Thanks,
Srinivas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What you're looking for is the "IsAllowed" function. It won't provide exactly what you want to get, but it's pretty close. See Ted's answer the following thread for more info: https://archive.sap.com/discussions/thread/1454103
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
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.