cancel
Showing results for 
Search instead for 
Did you mean: 

List of reports a user has access to using similar functionality of BI Platform tool

srinivasp74
Explorer
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

srinivasp74
Explorer
0 Kudos

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

Joe_Peters
Active Contributor
0 Kudos

Your query should include personal folders. It's possible that the account you are using to execute the query does not have permission to view the folders.

Joe_Peters
Active Contributor
0 Kudos

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