Oracle set user schema for tables window

More
6 years 2 months ago - 6 years 2 months ago #19851 by Phelps
I was wondering, for an Oracle connection, if you knew of anyway to alter the schema (user) that would show up in the tables window? Example: Logging on as user xxx but want the HR user tables to show up in the tables windows.
- Thanks again for a great product.
Last edit: 6 years 2 months ago by Phelps.

Please Log in or Create an account to join the conversation.

More
6 years 2 months ago #19852 by admin
This is not supported at the moment. We would need to modify our software for you.

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
6 years 2 months ago - 6 years 2 months ago #19853 by Phelps
Thanks for the reply.

If you would ever think about adding it, would be nice to have the ability to select a default schema(user) in Oracle similar to how you can select a default database in SQL Server.
-Thanks Steve
Attachments:
Last edit: 6 years 2 months ago by Phelps.

Please Log in or Create an account to join the conversation.

More
6 years 2 months ago #19857 by Phelps
Would it be possible to list all schema tables available to the user in the Database Browser Tables list?
They do show up in SQL Builder but not the Database Browser.

Attachments:

Please Log in or Create an account to join the conversation.

More
6 years 1 month ago #19869 by Peter.Jonson
Latest version loads the complete list of tables for all oracle schemas.
This might, however, lead to slow performance if you have a lot of tables.
We might revert I back if some of our customers complain

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
6 years 1 month ago #19872 by Phelps
Just download version 5.3.2.13, worked perfect. I did not think the load time was bad and I am loading about 43 schema. Faster than Oracle SQL Developer. If you ever think about putting in a user(schema) filter option that would be awesome, but working perfectly and very happy.
Thanks again for the support.
- Mr. Phelps

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save