Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
Database Application Development
This discussion is archived
on Nov 15, 2012 4:31 PM by Gary Graham-Oracle
unable to see packages / triggers etc in SQL Developer 3.1.07
Nov 15, 2012 3:34 PM
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
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: unable to see packages / triggers etc in SQL Developer 3.1.07
Nov 15, 2012 4:31 PM
in response to
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