When I log in with my developer user, the schema dropdown list remains grayed out thus not allowing me to access other schemas. Through Toad for Oracle however, I am able to login with the same user and access other schema objects. Does Toad Data Modeler use a different set of rights than Toad for Oracle?
Insufficient Privileges
In order to perform reverse engineer on other schemas, TDM users will need the following system privileges and Oracle roles:
Roles:
- Connect
- Resource
System Privileges:
- Create Session
- Select Any Table
Once these rights have been granted to the user, restart TDM and try to reverse engineer again.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy