3

I need to check the current user's java grants, something similar to what has been set by:

dbms_java.grant_permission('SCOTT','java.net.SocketPermission','*','connect');

Can this be done without system privs from the current account? If I need to do it with system privs, where should I look?

10gR2, if that makes a difference.

Mark Harrison
  • 297,451
  • 125
  • 333
  • 465

2 Answers2

19

This should show up in the DBA_JAVA_POLICY and USER_JAVA_POLICY views.

dpbradley
  • 11,645
  • 31
  • 34
-1
begin
  dbms_java.grant_permission(grantee           => 'CALL_RECORDING',
                             permission_type   => 'java.io.FilePermission',
                             permission_name   => 'D:/AES/-',
                             permission_action => 'execute,read,write,delete');
  commit;
end;
wahid
  • 41
  • 3