FDI 26ai ADW: GRANT SELECT ON SCHEMA OAX$DW to a custom database user?

Question

Is it possible to grant select any table on schema OAX$DW to a custom database user within a 26ai ADW? If so, please clarify any pre-requisite steps such as ADMIN or OAX_USER needing specific privileges before trying to run the grant statement.

Thanks & Regards,

Angel

JohnW-Oracle · Accepted Answer

Hi @Angel Torres-Vargas,

The grant "select any table" is not schema specific so it is not recommended.

The recommendation is to grant select on specific objects owned by OAX$DW to custom users.

Regards,

John