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?
Vous devez être connecté et disposer d'un contrat de maintenance en cours pour afficher les articles de la base de connaissances avancés.
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center