General OBIEE

Get Involved. Join the Conversation.

Topic

    new.bi
    How to get roles assigned to BI Reports
    Topic posted October 11, 2017 by new.biRed Ribbon: 250+ Points, tagged Fusion, OTBI, Report Output, Reports, Sample Reports, Setup/Administration, SQL 
    88 Views
    Title:
    How to get roles assigned to BI Reports
    Summary:
    How to get the roles assigned to BI Reports
    Content:
    Hi
    I need to a quick way (SQL or BI report) to get the roles assigned to reports (we have about 200 of them). Is there a SQL query I can run. Does anyone know what tables hold the report name to role attached to the report.
     
    thanks in advance