Disabling issue of SQL through Go URL in OBIEE 12c

3812020

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.

[Deleted User]

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

3812020

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]

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

Thank you for the help.