EXECUTE DIRECT DATABASE REQUESTS

3512682 · Nov 9, 2018 6:20AM

Hi Folks,

Is 'EXECUTE DIRECT DATABASE REQUESTS' has been deprecated for BI ADMINISTRATOR ROLE?

If yes, then what are the alternatives for accessing the DB directly?

Thanks

Robert Angel · Nov 9, 2018 6:24AM

it isn't, that I know of, have you seen ->

n.b. You also have the option to create an opaque view; -

3512682 · Nov 9, 2018 7:19AM

Even after setting "Allow" for "DDR" in Identity Manager for BIAdministrators Role, I am still seeing the same error.

Am I missing something here?

Gianni Ceresa · Nov 9, 2018 7:29AM

3512682 wrote:I am still seeing the same error.

So you have an error in front of you, that's new ...

Help the community in helping you

Robert Angel · Nov 9, 2018 7:31AM

You changed the setting against the connection pool also, as described in the link I posted?

3512682 · Nov 9, 2018 7:50AM

Finally, I got the results.

There was a mismatch between Roles from the privileges from Presentation Admin to Identity Manager.

Thanks guys for pitching in.

Oracle Analytics Cloud and Server