In our applications we use proxy-users.
We use it like this:
eg:
ALTER USER UTILS_UTLDOCUMENT_ORDS GRANT CONNECT THROUGH DUO_ADMIN;
conn duo_admin[UTILS_UTLDOCUMENT_ORDS]/*****@duors-d
Check via dba-view:
select *
from proxy_users;
After comparing the schema's (both the admin and the ords schema) via toad compare the 'special connect through grant' is not taken into account.
Is it an option to take these proxy grants into account?
Hi Christophe,
The Schema compare compares the objects owned by the schemas , not user and password and logon method of the schemas themselves. So it shouldn't matter if they connect by proxy or external or any other method. Compare either UTILS_UTLDOCUMENT_ORDS or DUO_ADMIN users (or both) as you see fit.
If you want to compare properties of the users (including authentication methods like proxies), then go to menu: Database -> Compare -> Databases to compare the users
-John