SqlDbx
You are not logged in.
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
Try to uncheck Tools->Options->Servers->Oracle "Use DBA_* views if available"
Offline
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
Last edited by garbuya (2016-01-06 16:44:47)
Offline
This is strange.
Please email to support and we will try to resolve this issue directly with you.
Offline
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
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