# \[Feature-7306\]Schemas not showing in Query Browser for Oracle DB **URL:** \ **Category:** Ignition\ **Tags:** database\ **Created:** [February 16, 2021, 10:16pm UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487 "2021-02-16T22:16:02Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![robert.buckler](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@robert.buckler](https://forum.inductiveautomation.com/u/robert.buckler)\ **Post date:** [February 16, 2021, 10:16pm UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/1 "2021-02-16T22:16:02Z")
Very new to Ignition and my current admin role in general. I have successfully connected to a couple of our company databases and am able to view all of the schemas in the Query Browser. I recently connected to one of our older Oracle databases and the schemas do not show up in the Query Browser. I am unfamiliar with all of the data we are collecting in that database and being able to browse through it is a must. ---
**Author:** ![cesrom](https://avatars.discourse-cdn.com/v4/letter/c/ea666f/32.png) [@cesrom](https://forum.inductiveautomation.com/u/cesrom)\ **Post date:** [February 17, 2021, 12:41am UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/2 "2021-02-17T00:41:04Z")
You could try the following. Go to your Gateway, then **Config** \> **Databases** \> **Connections** , regardless of the version. Edit the connection, and scroll all the way down and check **Show advanced properties** , and under **SQL Compatibility** enable the **Include Schema in Table Name**. In my case not all tables were listed, or displayed an error when I tried to see their columns using Query Browser, and enabling that solved my issue on MSSQL. ---
**Author:** ![robert.buckler](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@robert.buckler](https://forum.inductiveautomation.com/u/robert.buckler)\ **Post date:** [February 18, 2021, 12:32am UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/3 "2021-02-18T00:32:57Z")
**Include Schema in Table Name** seems to have no effect. I have tried to use different Translations as well. I cannot confirm which version of Oracle so I have not yet tried to update the JDBC driver. ---
**Author:** ![cesrom](https://avatars.discourse-cdn.com/v4/letter/c/ea666f/32.png) [@cesrom](https://forum.inductiveautomation.com/u/cesrom)\ **Post date:** [February 22, 2021, 10:43pm UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/4 "2021-02-22T22:43:04Z")
Could it be a matter of granting access to the desired schemas, then? ---
**Author:** ![robert.buckler](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@robert.buckler](https://forum.inductiveautomation.com/u/robert.buckler)\ **Post date:** [March 14, 2021, 4:35pm UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/5 "2021-03-14T16:35:30Z")
I have been told that the login info we are using has been granted the correct permissions. I am unable to verify personally, I do not have access. I was just given the db login info. Thank you for the advice though, I will find a way to verify this. ---
**Author:** ![gsconfienza](https://avatars.discourse-cdn.com/v4/letter/g/2acd7d/32.png) [@gsconfienza](https://forum.inductiveautomation.com/u/gsconfienza)\ **Post date:** [July 1, 2021, 2:43pm UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/6 "2021-07-01T14:43:59Z")
Same issue here. Were you able to found a solution? ---
**Author:** ![JoeF](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@JoeF](https://forum.inductiveautomation.com/u/JoeF)\ **Post date:** [August 25, 2021, 3:10pm UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/7 "2021-08-25T15:10:31Z")
Also experiencing this issue in 8.0.17. Anything unique with Oracle DBs? I haven’t noticed displaying tables to be a problem with read-only permissions. ---
**Author:** ![Sourabh\_Ambildhuke](https://avatars.discourse-cdn.com/v4/letter/s/f1d935/32.png) [@Sourabh\_Ambildhuke](https://forum.inductiveautomation.com/u/Sourabh_Ambildhuke)\ **Post date:** [March 30, 2022, 7:59am UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/8 "2022-03-30T07:59:30Z")
Hi All, Did any of you find the solution or any way how we can see schema in Ignition. ---
**Author:** ![Ahiero](https://avatars.discourse-cdn.com/v4/letter/a/a698b9/32.png) [@Ahiero](https://forum.inductiveautomation.com/u/Ahiero)\ **Post date:** [September 29, 2022, 8:25pm UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/9 "2022-09-29T20:25:12Z")
We have the same issue here with an Oracle 12.2 database. I am using the same account credentials from Oracle Sql Developer with the search\_path property and the connection and filtering works. I have tried jdbc connectors 8, 10, and 11 for Ignition 8.1.7 with no success. I have tried _search\_path_ and _currentSchema_ independently as both extra connection properties and url parameters with no success. Is there a way to show the available tables and views in the database query browser for an Oracle database when the login used is not the owner? ---
**Author:** ![Daniel\_Drendall](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@Daniel\_Drendall](https://forum.inductiveautomation.com/u/Daniel_Drendall)\ **Post date:** [January 9, 2023, 9:40pm UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/10 "2023-01-09T21:40:11Z")
Best ive found is this article: > **[ORA-00942 table or view does not exist Solution](https://www.databasestar.com/ora-00942/)** > > Have you gotten an ORA-00942 error? I’ll explain the cause and the solution of the error in this article. ---
**Author:** ![obober](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/obober/32/67865_2.png) [@obober](https://forum.inductiveautomation.com/u/obober)\ **Post date:** [March 3, 2023, 12:57am UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/12 "2023-03-03T00:57:42Z")
Hi all, I've been working with a customer regarding this issue, and made some discovery. I thought I'd share. Essentially, prior to 7.9.1, Ignition would gather all DB tables from Oracle. However, this would cause significant performance issues on the GW and Designer when opening the DB Query Browser, because Oracle would return thousands of system tables. This was considered a bug, and was patched in 7.9.1. Now, Ignition will only return tables that are owned by the user defined in your DB connection. So, if you want to see tables in the DB Query Browser, the tables need to be owned by your defined user. ---
**Author:** ![obober](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/obober/32/67865_2.png) [@obober](https://forum.inductiveautomation.com/u/obober)\ **Post date:** [March 6, 2023, 10:02pm UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/13 "2023-03-06T22:02:29Z")
During my troubleshooting with the customer, I figured that customers should have the option to show all tables from all users if they wish. I opened feature request IGN-7306, which will allow y'all to display all Oracle DB tables in the DB Query Browser if you would like. I do not have an estimate on when (or even if) the feature will be implemented. Hopefully I remember to return to this forum post when the feature is implemented. In the meantime, hang tight! ---
**Author:** ![dick.willis](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@dick.willis](https://forum.inductiveautomation.com/u/dick.willis)\ **Post date:** [October 11, 2024, 5:46pm UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/14 "2024-10-11T17:46:15Z")
Has anybody tried to use ORACLE objects that belong to others in their queries? In the article, there was an example "SELECT \* FROM mary.Employee" when I'm user "bob" In my example, I'm "Ignition\_RO", and I want to use tables owned by "QUALITY". So the query I want to run is "SELECT \* FROM quality.employee" This workw fine in OracleSQLDesigner. But ... in the NamedQuery and the DatabaseQueryBrowser tool, running that same SQL Statement returns 00942 - "table or view does not exist". For some queries that work fine in OracleSQLDesigner, when I run those same queries as NamedQueries or in the DatabaseQueryBrowser too, I will get error 01031 - "insufficient privileges" How is SQLDesigner different from NamedQuery in terms of how it is passing credentials? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [October 11, 2024, 6:07pm UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/15 "2024-10-11T18:07:29Z")
SQLDesigner is making a native Oracle connection. Ignition makes a JDBC connection through the Oracle-supplied driver. Most DB brands have vendor-specific behavior on their own native connections. JDBC is standardized. You should examine the Oracle JDBC documentation to look for possible explanations. ---
**Author:** ![dick.willis](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@dick.willis](https://forum.inductiveautomation.com/u/dick.willis)\ **Post date:** [October 11, 2024, 6:11pm UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/16 "2024-10-11T18:11:39Z")
Ok ... my first worry was just syntax. Since it seems like the syntax of using another schema-user is allowed and parsed properly, I'm guessing that it's going to be a permissions problem ... just not sure what the question is that I'll ask my DBA team ... hopefully they'll know the diff between JDBC and Native connections. Thanks for the encouragement. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [October 11, 2024, 6:13pm UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/17 "2024-10-11T18:13:40Z")
JDBC drivers usually allow a large variety of permissions/constraints to be specified in the JDBC URL and/or its "Extra Connection Properties". Typically brand-specific. You should look at your gateway's connection settings for this DB name. ---
**Author:** ![Chaz\_Gunning](https://avatars.discourse-cdn.com/v4/letter/c/85f322/32.png) [@Chaz\_Gunning](https://forum.inductiveautomation.com/u/Chaz_Gunning)\ **Post date:** [August 13, 2025, 1:52pm UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/18 "2025-08-13T13:52:40Z")
> [@obober](#): > > e request IGN-7306, which will allow y'all to display all Oracle DB tables in the DB Query Browser if you would like. I do not have an estimate on when (or even if) the feature will be implemented. Has there been any update on feature request IGN-7306? Not having the Oracle DB schema continues to be a pain point for our team. ---
**Author:** ![obober](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/obober/32/67865_2.png) [@obober](https://forum.inductiveautomation.com/u/obober)\ **Post date:** [August 18, 2025, 4:29pm UTC](https://forum.inductiveautomation.com/t/feature-7306-schemas-not-showing-in-query-browser-for-oracle-db/43487/19 "2025-08-18T16:29:41Z")
Hey Chaz, unfortunately there has been no update on the feature request, likely due to the focus on 8.3.