This discussion is archived
1 Reply Latest reply: Nov 15, 2012 8:31 AM by Gary Graham RSS

unable to see packages / triggers etc in SQL Developer 3.1.07

872153 Newbie
Currently Being Moderated
Hi

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.

Thanks.

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
DB 11.2.0.3.0

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points