Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 19, 2017 at 01:32 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 19, 2017 at 02:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.