#331 Oracle Schema objects do not appear in the object tree

2.1final
closed-invalid
Rob Manning
Core (461)
5
2006-01-29
2006-01-11
Mark Shives
No

Oracle schema objects to not appear in the object tree
with the exception of the current logged in users
schema, sys, and users.

No object tree filtering is turned on.

The sql executed from the sql tab that references other
schemas work with no problems.

This makes it difficult to use when needing to look at
tables, views, and stored procedures in other schemas.

Using Oracle 9.2.0 jdbc drivers found in classes14.zip.

Discussion

  • Rob Manning
    Rob Manning
    2006-01-11

    • status: open --> pending-invalid
     
  • Rob Manning
    Rob Manning
    2006-01-11

    Logged In: YES
    user_id=1287991

    This feature was added in 2.1. It is intended to work
    this way.

    You will only see schemas to which you have access to one
    or more tables (user_tab_privs). If you want to see other
    schemas, then login as system, sys or some other user
    with SYSDBA role. Otherwise, you can grant privileges to
    one or more tables in other schemas.

    Rob Manning

     
  • Rob Manning
    Rob Manning
    2006-01-11

    • assigned_to: colbell --> manningr
     
  • Rob Manning
    Rob Manning
    2006-01-29

    • status: pending-invalid --> closed-invalid
     
  • Jesper Nielsen
    Jesper Nielsen
    2006-05-04

    Logged In: YES
    user_id=861574

    I would agree with Mark Shives that the new featuer is less
    than desireable in the way it is currently implemented. I
    have reverted to version 2.0 final in order to avoid it.

    It is very possible to have access to tables in other
    schemas that are not currently listed in the object tree.

    In all the databases I access that is the case and it pretty
    much renders the new versions useless as I cannot browse the
    schema's to confirm tablenames etc. I work in a major
    organisation and I am not going to be granted SYSDBA roles
    ever in a million years.

    Please reconsider the implementation of this feature.

     
  • Rob Manning
    Rob Manning
    2006-05-04

    Logged In: YES
    user_id=1287991

    kruse73,

    I need more information about exactly how you have access to
    the tables in other schemas which the Oracle plugin fails to
    detect. For instance, if the DBA runs the following SQL:

    grant select on test.table to kruse73;

    Then the Oracle plugin should allow the schema called
    "test" to appear in the object browser. Under the "test"
    schema, the tables item will show only the table called
    "table". My testing shows that this works correctly in
    2.2 final.

    An alternative would be to not install the Oracle plugin
    which is what filters the schemas in the object tree based
    on which ones the user has access to.

    Rob

     
  • Jesper Nielsen
    Jesper Nielsen
    2006-05-05

    Logged In: YES
    user_id=861574

    Rob,

    Thanks for the follow up. One obvious other way of having
    permissions to other schemas and tables is through group
    membership. However I think the major one I am having issues
    with here is that I cannot see objects that has been granted
    permissions to Public.

    Objects with public privileges are not shown in the object
    browser.

    Cheers,

    /Jesper