Hi,

This just maybe to be a limitiation of V8. Here is my problem. I want to compare the objects in a schema in dev with prod. The prod target user, not a schema, has select_catalog_role so I can see all DDL for any user on the prod instance when logged in as target user through the data dictionary dba views. I can not select on any views or tables however. This is to be expected as target user does not have select permission on any schema objects. However, compare from dev does not see the DDL on prod. A blank file is returned when I bring up ExamDiff. Any ideas why compare does not work under the above situtation.

Thanks