@Barbara - I'm SYSDBA in this scenario, the only difference is the ORACLE version.]]>_jum2012-07-05T05:50:12-00:00Re: can't grant java.io.FilePermissionhttp://www.orafaq.com/forum/./mv/msg/182535/559626/#msg_559626
Quote:

I'm SYSDBA in this scenario, the only difference is the ORACLE version

- Never ever use SYS (or SYSDBA) but for maintenance purpose (startup, shutdown, backup, recover)
- SYS/SYSDBA is special
- SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the immediate answer)
- SYS/SYSDBA does not act like any other user
- When you use SYS/SYSDBA Oracle deactivates some code path and activates others
- Whatever you do with SYS/SYSDBA will neither validate nor invalidate the same thing with any other user.

NEVER EVER use SYS/SYSDBA for anything that can be done by another user.
Use SYS/SYSDBA ONLY for something that can't be done by someone else.

Regards
Michel
]]>Michel Cadot2012-07-05T08:56:34-00:00Re: can't grant java.io.FilePermissionhttp://www.orafaq.com/forum/./mv/msg/182535/559650/#msg_559650
Changed the USER DEFAULT ROLE and now the session_roles shows DBA too, but the result is the same...
The ORA-29532 error only takes place, if a valid USERNAME is used for GRANTEE, in the other cases the procedure gives no error - but of course no entry in the DBA_JAVA_POLICY.
I wonder, if something in the JAVA-Installation of the server went wrong. But all JAVA objects are vaild.