Oracle Analytics Cloud and Server

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

Categories

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

Disabling issue of SQL through Go URL in OBIEE 12c

Received Response
1
Views
4
Comments
3812020
3812020 Rank 1 - Community Starter
edited Aug 13, 2024 5:20PM in Oracle Analytics Cloud and Server

Is there any way to disable issue of SQL from Go URL in OBIEE 12c? If yes, how can we do this? Any help would be appreciated.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Please explain your issue more precisely. "disable issue of SQL from Go URL" doesn't really tell us what your problem is.

  • 3812020
    3812020 Rank 1 - Community Starter

    Thank you for your response. Yes, sure. I am explaining the scenario:

    Scenario:
    Right now, if someone is hitting the url such as-
    https://<host>/analytics/saw.dll?Go&SQL=select+<column_name>+from+<SUBJECT_AREA.table_name>

    then the logical sql is being executed against the RPD presentation layer in order to return the result from the data warehouse.

    What we want to achieve:
    We want to disable this issuance of sql from go url. The bottom line is, we don't want to allow any BI consumer to use this Go url feature. How can we achieve this?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    No, you can't disable that inside of OBI itself but if you have some kind of reverse proxy in front, that one can handle it and just refuse those requests.

  • 3812020
    3812020 Rank 1 - Community Starter

    Thank you for the help.