1 Reply Latest reply: Nov 15, 2012 10:31 AM by Gary Graham-Oracle RSS

    unable to see packages / triggers etc in SQL Developer 3.1.07


      The user has SELECT_CATALOG_ROLE role granted but still cannot see packages of other users.

      Is there anything else I need to grant to this user in order that it may have visibility?

      Can't see package body in SQL Developer version 3.1 covers it to a point but I need more please.


      This user has SELECT AND TABLE and CREATE SESSION.

      When I run this on the database connecting as this user I get rows returned which tells me its a SQL Developer thing?
      select text from dba_source where name like '%a_package_name%';

      Which could also mean I need to reinstall the damn thing doesn't it?

      SQL Developer 3.1.07

      Edited by: 869150 on Nov 15, 2012 6:41 AM

      Edited by: 869150 on Nov 15, 2012 7:07 AM

      Edited by: 869150 on Nov 15, 2012 7:34 AM