I was under the impression that OBIEE uses the first listed and available connection pool when executing queries, so that if I set No Access permission for the first listed connection pool it would not be used at all.
However, that is not the case. This connection pool IS being used.
My connection pool list looks like this:
As noted in the first screenshot, the Prod connection pool is tagged as No Access for every role. Therefore, I would expect the Dev connection pool (which is tagged as Read-Only for all roles) to be used. That is not happening. There are additional columns in the Dev database and the RPD. When I attempt to access those columns in Answers, an error message tells me that the columns do not exist. But if I delete the PROD connection pool, the Answers query runs just fine. This tells me that OBIEE is running the query against the first connection pool irrespective of the fact that it appears to be disabled for all roles.
The Prod connection pool looks like this:
These connection pools are in my Dev RPD. My goal is to be able to "enable" or "disable" the first connection pool so that I can easily run queries against either Prod or Dev, without needing to change the credentials constantly within a single connection pool. With just 6 clicks I can either enable or disable the first connection pool, upload the RPD, and be ready to roll.
What might I be missing? We are on Oracle Analytics Cloud, version 12.2.5.1.0
