Privileges

ORAdiff is live – compare two Oracle Database and Patch releases

Did you ever wanted to find out the differences between two Oracle database releases? Today, I am super-super excited. Especially, since this was a long journey. And I have to thank our entire team,  Rodrigo especially but also Bill and all the others working and helping here. THIS is the tool many of you have looking for since years. It is time now, ORAdiff is live – compare two Oracle Database and Patch releases.

ORAdiff is live - compare two Oracle Database and Patch releases

What is ORAdiff?

This tool is made for you. It allows you to compare two Oracle releases to each other. And not only core

Continue reading...

New Behaviour in Oracle Database 12c and 11.2.0.4: SELECT ANY DICTIONARY with reduced privilege set

You’ve just upgraded to Oracle Database 12c – but your favorite admin tool receives an ORA-1031: Insufficient Privileges after connection?

Then the reason may be the reduced set of privileges for the SELECT ANY DICTIONARY privilege. This privilege does not allow access to tables USER$, ENC$ and DEFAULT_PWD$, LINK$, USER_HISTORY$, CDB_LOCAL_ADMINAUTH$, and XS$VERIFIERS. Actually such changes are not new. For instance in Oracle 10.1 we removed the access to  LINK$ in SELECT ANY DICTIONARY (well, this may have happened because the dblink’s password was stored in clear text in LINK$ – a misbehavior which is fixed since

Continue reading...