A user with these privileges:
1. SELECT ANY SEQUENCE
2. SELECT ANY TABLE
3. SELECT ANY DICTIONARY
Using the same user, in Toad for Oracle, can see everything, including all the Oracle objects’ scripts in all the schemas, due to the parameter :
CHECK FOR ACCESS TO DBA VIEWS
But, in Toad DataModeler, there is no such parameter and I’m only able to get a few objects in the Reverse Engineering option. The only way can Reverse the missing objects is to get full DBA privileges, but that's not possible.
Is there a way to get the same option in DataModeler without DBA privilege?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.