|
211 KB
Can you verify whether this occurs in Oracle 11g as well?
I was not able to reproduce in Oracle 11g or lower versions. This is specific to 12c with change in system catalog table
I was not able to reproduce in Oracle 11g or lower versions. This is specific to 12c with change in system catalog table
Its seems that oracle has changed the way the ALL_DEPENDENCIES view is deciding if you have access to see the objects. For some reason even logged in as SYS DBA I am not able to extract the dependencies I create on a users table. If the user has access to the DBA tables he will just need to modify his connection property and in the advance tab select [USE DBA Views]... this will have the extraction use the ALL_DEPENDENCIES witch will have the information avaliable
Its seems that oracle has changed the way the ALL_DEPENDENCIES view is deciding if you have access to see the objects. For some reason even logged in as SYS DBA I am not able to extract the dependencies I create on a users table. If the user has access to the DBA tables he will just need to modify his connection property and in the advance tab select [USE DBA Views]... this will have the extraction use the ALL_DEPENDENCIES witch will have the information avaliable
unable to fix as the issue is on the database side.
unable to fix as the issue is on the database side.
Issue #9944 |
Closed |
Won't Fix |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
Can you verify whether this occurs in Oracle 11g as well?