Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Restricting access to tables/data sources with a privillege/role

Accepted answer
31
Views
3
Comments
NagarajuKanukanti
NagarajuKanukanti Rank 2 - Community Beginner
edited Jul 17, 2024 10:00PM in Oracle Analytics Publisher

is there a way to restrict the developers writing the SQL's based on the HCM/FSCM data source ( not everyone should have access to HCM data source)

Best Answer

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist
    edited Jul 17, 2024 10:49PM Answer ✓

    Hi @User_N5XHC

    Okay got it. As of now we don't have any provision from BIP UI to apply the restriction on Seeded Data source as these are delivered sources.

    The ApplicationDB_*  data sources are specific to FusionApps.  The security for this is controlled by applSession / FND tables.

    I just confirmed the same from BIP dev team.

    Regards,

    Arjun

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @User_N5XHC

    You can able to restrict the data source access. Open the Data source Connection apply the security

    image.png

    We don't have any other process to restrict w.r.t BI Publisher.

    Regards,

    Arjun

  • NagarajuKanukanti
    NagarajuKanukanti Rank 2 - Community Beginner
    edited Jul 17, 2024 10:26PM

    Thanks for the quick answer.

    If the data source is of below types - we can restrict. But we are looking for seeded data sources to restrict (ApplicationDB_FSCM,ApplicationDB_HCM)

    JDBC Connection
    JNDI Connection
    File
    LDAP Connection
    OLAP Connection
    Web Service Connection
    HTTP Connection
    Content Server