Compare Data "ORA-01031" – insufficient prvileges (4215628)

When trying to compare data in the same database between different users:

After choosing Connection type (the same), Object type (Table - the same), Object owner (Different), Object Name (different) and pressing Finish button, get an error information -

ORA-01031 – insufficient prvileges.

RESOLUTION

Go to Database|Spool SQL|Spool SQL to Screen,
Then attempt to do a data compare.
Scan throught he Scanned SQL at the end of the screen and see exactly what this ORA is firing on.

E.G

----------------------------------

Session: TEMP1@XE

Timestamp: 08:59:17.676

select Src.*, Src.Rowid from TEMP2.EMP1 Src where 0=1

Error: ORA-01031: insufficient privileges

See can you run the following select statement against TEMP1@XE

select Src.*, Src.Rowid from TEMP2.EMP1 Src where 0=1;

If it is failing with ORA-01031, then you will need to grant Select privileges temp2.emp1 to temp1

Login in as TEMP2.EMP
And run:
Grant SELECT on TEMP2.EMP1 to TEMP1;