Compare User Objects Question

[cassiusdrow]

How can I use Compare User Objects to compare two schema's objects when I don't have the password for one of the schemas?

For example, on our production machine (prod), my schema (user) has read access to everything owned by the application schema (app), but I don't have the application schema's password. While on our test machine (test), I have access to the application schema's password.

I would like to compare objects from app@test to objects owned by app@prod, but log into prod as user@prod.

Is there any way to do this in v5.1?

 

[patch]

I would like to compare objects from app@test to objects owned by app@prod, but log into prod as user@prod.

make sure the user@prod has dba role, that way, you can check the code from app@prod schema. You could even automate this by writing code comparing packages etc using the data-dictionary views (all_source)

hope this helps,
Patch

------------------
Check out: http://www.oracledeveloper.nl

 

[Marco Kalter]

This is currently not possible. For the Compare User Objects tool you have to connect as the object owner for both the source and the target session.

I guess we could add a separate option for the connection and the object owner. If the connection has DBA privileges, this can be useful. I have added an enhancement request for this.

------------------
Marco Kalter
Allround Automations

 

[cassiusdrow]

Patch - Thanks for the suggestion, maybe in my free time (ha!) I'll write something like this.

Marco - Thanks for adding this to the list. It will make it much easier for developers who do not have direct access to their production environments.