Cannot see Oracle SYS views

The Oracle data dictionary is owned by the SYS schema. This is where things like the all_tables and all_users data dictionary views are located. Why can’t I query the Oracle SYS schema in Dremio? Whichever data dictionary view I try, Dremio says it cannot find it.

@swm4

Dremio is used as a SQL engine to query application tables. What is the username you are entering in the Dremio UI Oracle source? Have you tried SYS there?

I have tried several different Oracle users in Dremio. All have access to SYS and successfully can query the data dictionary views through tools such as SQL Developer. It’s when Dremio is connected to Oracle that the data dictionary is not available. It’s not a new issue either. This has been a limitation since we installed Dremio in 2019.