Return
-
Title
Unable to access other schemas -
Description
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?
-
Cause
Insufficient Privileges
-
Resolution
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.