Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

View all grants on database object

Robin RMar 21 2014 — edited Mar 21 2014

Hello,

I want to see all the grants on a package which is not owned by my user. I currently see only my own grant. Can this be done in SQL Developer (4.0.1)?

Example:

My user (ABC) logs into database and via Other users>Packages navigates to SYS.UTL_FILE. User ABC has execute rights on this package and has DBA role in database. I can view information on this package but only see by grants on tab 'Grants'. I would like to see all the grants (for other users) on this package. In Toad with the same user/database I see all the grants. When I export the package (with Grants) all the grants are in the script, so it should be possible. I don't know the SYS password.

Why don't I see all the grants? Can this be changed (properties)? Is this a feature or a bug ?

Thanks,

Robin

Comments

gimbal2
If you have to resort to GCJ, you are already on thin ice and should rethink your strategy. I'd say you don't need Java but you need a native C/C++ application. In any case, a Google search for "gcj java comm" resulted in this as the first hit:

http://stackoverflow.com/questions/1835531/java-compiled-with-gcj-using-javax-comm-api-possible

Amazing what a simple Google query can tell you in under a second, huh?
EJP
GCJ is not a Java compiler, and it relies on a library called GNU CLASSPATH which isn't Java either. Don't use it, and don't ask about it here, this site is for Java as defined by the Sun/Oracle specifications.
860005
Thank you for replying.

I have a complete java program, the problem is that i dont know how to compile it on embeded linux 2.6.86. I googled it and gcj came up in search results. Can you assisst me in this problem.

I m using ok6410 development kit (arm board). It is with wince 6 or linux 2.6.86. I have whole coding in java which is tested in windows OS.

How can i compile my code in above mentioned kit?
860005
Yes i did googled it and came accross that answer which i didnt understand. Can u suggest me any other compile that will run in

Embeded linux 2.6.86 (Debian)

The problem is i have done all my coding in java.
gimbal2
857002 wrote:
Yes i did googled it and came accross that answer which i didnt understand. Can u suggest me any other compile that will run in

Embeded linux 2.6.86 (Debian)

The problem is i have done all my coding in java.
Java classes are cross-platform. If there is a Java runtime for this Linux version then you can run them even if you compiled them on Windows. If there is no compatible Java runtime then you should have done your research before writing the code.
EJP
How can i compile my code in above mentioned kit?
Download and install a JDK from Sun/Oracle for the platform and use the 'javac' command.
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 18 2014
Added on Mar 21 2014
#sql-developer
2 comments
169 views