compare objects when you are not the owner but have 'view' rights

[psneeley]

Is there a way to compare objects (i.e. packages) when you are not the owner and simply have 'view' rights?

Example: I can login as the 'owner' in the development database, and I'd like to compare that object to that same object residing in the Production database. But, I only have 'view' rights in Production (there is no way I would be allowed to login regularly as the owner of the objects of the production DB).

Thanks,

Psneeley

 

[ScottMattes]

Not an easy way, that I know of.

I am writing a plugin to use the ExamDiff program that comes with PLSD to compare code like you are asking. Right now it will compare the program unit that you have open to a disk file. As soon as I get the time, and Marco can explain to me how I am using the plugin interface wrong, it will be able to compare source in the DB.

You can manually do the same thing by viewing the code and saving them both to disk and then using ExamDiff to compare them.

 

[Marco Kalter]

There is an existing enhancement request to allow you to provide the schema in addition to the target connection for the compare user objects tool. This will solve your problem in the future.