What are the different ways to access the Oracle ADW database without having the relevant User name

Question

Is there a way to access the Oracle AADW database without being assigned the FAW Service Administrator role, using only a native database username and password with read/write privileges? If so, can this access be provisioned and managed dynamically?

Bhaskar Konar · Answer

Hi @User_7AIAG,

You may want to have a look at the following Oracle blog, as it discusses an approach for creating a custom schema/user in ADW and replicating the required access from the standard OAX_USER account.

It might be useful depending on your access requirements and security model:

FDI: Replicating Access from OAX_USER to a Custom Schema:

https://blogs.oracle.com/analytics/fdi-replicating-access-oaxuser-customschema

Hope this help.

Thank you.