Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    angela ahrens
    manager data access for users
    Topic posted September 20, 2019 by angela ahrensRed Ribbon: 250+ Points, tagged BI Publisher 
    21 Views, 1 Comment
    Title:
    manager data access for users
    Summary:
    manage data access for users - users without data access
    Content:

    On Manager data access for user page

    what sql or tables do i use to get USERS WITHOUT Data Access

    I found table for users with data access. FUN_USER_ROLE_DATA_ASGNMNTS but need to find how to get the ones with users without data access

    Comment

     

    • Tom Strudley

      Hi Angela

      Can you write a query in BIP where a user does NOT EXISTS in the FUN_USER_ROLE_DATA_ASGNMNTS table?

      Thanks

      Tom