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?
In order to perform reverse engineer on other schemas, TDM users will need the following system privileges and Oracle roles:
- Create Session
- Select Any Table
Once these rights have been granted to the user, restart TDM and try to reverse engineer again.