Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Accepted answer
11
Views
1
Comments
Angel Torres-Vargas
Angel Torres-Vargas Rank 4 - Community Specialist
in Oracle Fusion AI Data Platform Forum

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

Tagged:

Best Answer

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics & AI Coach
    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