begin dbms_java.grant_permission(upper('%user'), 'java.io.FilePermission','<>', 'read'); dbms_java.grant_permission(upper('%user'), 'java.net.SocketPermission','*', 'connect'); dbms_java.grant_permission(upper('%user'), 'java.util.PropertyPermission','*', 'read,write'); end; / grant AQ_USER_ROLE to %user;