Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#795 Schema-Clutter in SQL-Editor (TOra 2.1.1)

open
nobody
Oracle (75)
5
2012-12-13
2010-02-08
MOe
No

Precondition: Different users in 1 databse using the same tablenames.
Problem:

*Connected to userB, "select * from tab1" shows data from userA.tab1.
Whereas selecting from userB.tab1 works as expected.

"Discribe under cursor" on tab1 does also show table userA.tab1.

Installed from tora-2010-01-11-win32.zip on Windows XP SP3, with Oracle-Client 9.2
Database Server Linux x86_64, with Oracle Server 10.2

Discussion

  • MOe
    MOe
    2010-02-08

    Screenshot

     
    Attachments
  • What is selected in your 'current schema' (popup button in upper right corner of UI)? If 'userA', this is expected behavior, regardless of who you are logged in as.

     
  • MOe
    MOe
    2010-02-08

    Oh no.
    I connect as userB and there is userA selected in 'current schema'. The 'bug' is rather the selected schema.

     
  • MOe
    MOe
    2010-02-09

    If i log in as userA there should be userA pre-selected in my current schema. Nobody would expect to have an other default-schema than the one connected to.