Oracle set user schema for tables window

  • Posts: 8
  • Thank you received: 0

Oracle set user schema for tables window was created 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.
11 months 1 week ago #19851

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

  • Posts: 8125
  • Karma: 33
  • Thank you received: 510

Replied by admin on topic Oracle set user schema for tables window

This is not supported at the moment. We would need to modify our software for you.
Mike
11 months 1 week ago #19852

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

  • Posts: 8
  • Thank you received: 0

Replied by Phelps on topic Oracle set user schema for tables window

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
11 months 1 week ago #19853
Attachments:

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

  • Posts: 8
  • Thank you received: 0

Replied by Phelps on topic Oracle set user schema for tables window

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.

11 months 5 days ago #19857
Attachments:

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

  • Posts: 1138
  • Karma: 3
  • Thank you received: 135

Replied by Peter.Jonson on topic Oracle set user schema for tables window

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
Support Analist
10 months 4 weeks ago #19869

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

  • Posts: 8
  • Thank you received: 0

Replied by Phelps on topic Oracle set user schema for tables window

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
10 months 4 weeks ago #19872

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

 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies