SqlDbx Forum

SqlDbx

You are not logged in.

#1 2016-01-05 14:37:34

garbuya
Member

Bug - not all objects in Oracle schema are visible

When I connect to a database and then select a production schema (different from my own) I can see all tables, but I can see only very few views, types, functions, packages and procedures
I have a read-only access to all objects in this production schema and when I use another tool, such as SqlDeveloper, I can see all objects.
I need to generate scripts for all objects and create a test database, but obviously "Tools-Generate Scripts" only generates what I can see.
Is it a bug ?  How to fix it?
Same in ver 4.7 thru 4.12

Last edited by garbuya (2016-01-05 14:46:00)

Offline

#2 2016-01-06 10:05:06

sqldbxhelp
Administrator

Re: Bug - not all objects in Oracle schema are visible

Try to uncheck Tools->Options->Servers->Oracle "Use DBA_* views if available"

Offline

#3 2016-01-06 15:23:15

garbuya
Member

Re: Bug - not all objects in Oracle schema are visible

It is already unchecked

I don't see triggers and most of code in schema where I have the read-only access
This is what I can see in SqlDbx and what I can see in Oracle SqlDeveloper
There is more then one function in the schema and there are triggers and packages
SqlDbx vs SqlDeveloper

Last edited by garbuya (2016-01-06 16:44:47)

Offline

#4 2016-01-06 23:02:42

sqldbxhelp
Administrator

Re: Bug - not all objects in Oracle schema are visible

This is strange.
Please email to support and we will try to resolve this issue directly with you.

Offline

#5 2016-02-01 09:29:54

garbuya
Member

Re: Bug - not all objects in Oracle schema are visible

I did email to support and get back a query you are running.
It selects from SYS.ALL_
Not every shop grants permissions to users to do it.
I suggested to union SYS.ALL_ and SYS.DBA_ objects 
This will give you much better list of objects
Will it be implemented??

Offline

#6 2016-02-22 10:22:53

garbuya
Member

Re: Bug - not all objects in Oracle schema are visible

This bug in 4.13 still not fixed

I replied to your support team with a solution -- union select from SYS.ALL_xxx and SYS.DBA_xxx but it looks like it is not implemented
Any plans to implement it in the future??

Offline

Board footer

Powered by FluxBB