0 Replies Latest reply on Feb 14, 2015 10:26 AM by jmarton

    Built-in reports on Locks does not work on 12cR1, using SQL Developer 4.1 EA1


      The built-in reports Locks by User and Blocking Locks by User (found in Data Dictionary Reports/Database Administration/Locks) does not works in Database 12cR1 with a user having SELECT ANY DICTIONARY privilege. Also a user having DBA role is not enough in 12cR1. In 11gR2, having SELECT ANY DICTIONARY is enough.


      Error displayed: ORA-01031: insufficient privileges


      This might be caused by direct referencing of sys.user$ internal object in the view's definition.



      Software versions used:

      SQL Developer version:

      Oracle JDK: 1.8.0_31, 64bit, Linux

      Instant client: x64-

      DBMS: Oracle Database 12c Enterprise Edition Release - 64bit Production, non-CDB configuration