Example 6-12: Listing URL-related Java security policies in Oracle8i

PROMPT +==========================================================+
PROMPT | Your URL, File, and Debug-Related Java Security Settings |
PROMPT +==========================================================+
set pages 999
column "Permission" format a30
column "Name" format a20
column "Action" format a15
column "Enab?"  format a5
column "Key"    format 99999
SELECT SUBSTR(type_name,INSTR(type_name,'.',-1)+1)||CHR(10)||
       '('||SUBSTR(type_name,1,INSTR(type_name,'.',-1)-1)||')'
        AS "Permission",
       name      AS "Name",
       action    AS "Action",
       DECODE(SUBSTR(enabled,1,1),'E','Y','N')   AS "Enab?",
       seq       AS "Key"
 FROM user_java_policy
WHERE GRANTEE_NAME IN (USER,'JAVADEBUGPRIV') /* Eliminate PUBLIC privs */
  AND (type_name = 'java.net.SocketPermission'
       OR type_name = 'java.io.FilePermission'
       OR type_name = 'java.lang.RuntimePermission'
       OR type_name = 'java.util.PropertyPermission'
       OR (    type_name = 'oracle.aurora.security.JServerPermission'
           AND      name = 'Debug')
       )
ORDER BY 1,3,2
/