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
The SELECT_CATALOG_ROLE should be sufficient as far as privileges go. I cannot recall at the moment, but there may well have been a bug or two fixed between 3.1.07.42 and 3.2.20.09.87 that solves this. Please try upgrading.
SQL Developer Team