Toad compare "GRANT CONNECT THROUGH" detection

hi

I am using toad compare schema's:
One schema has the "GRANT CONNECT THROUGH" option
eg. ALTER USER SOMEOWNERSCHEMA GRANT CONNECT THROUGH SOMEPROXYSCHEMA;

After comparing the schema's the difference is not detected.

Is it an option to detect this kind of difference?

Regards

Christophe

Hi Christophe,

I know Database Compare will handle this. Schema Compare is really more about the objects inside the schema. For Schema Compare, the sync script is intended to be run by the target schema, so a schema might not be able to grant itself "connect though some other schema".

On Database Compare, you could limit it to compare only users, and even specify just the one user to compare if you want (under "Filters").

Another place you could do this is Single Object Compare.

-John

Perfect! Thanks