Enhancing Security - Expert Oracle and Java Security - page 316

m_com_pager_no OUT VARCHAR2,
m_sms_phone_no OUT VARCHAR2,
m_sms_carrier_url OUT VARCHAR2,
m_email OUT VARCHAR2,
m_ip_address OUT v_two_fact_cd_cache.ip_address%TYPE,
m_cache_ts OUT VARCHAR2,
m_cache_addr OUT v_two_fact_cd_cache.ip_address%TYPE,
m_application_id v_two_fact_cd_cache.application_id%TYPE,
m_err_no OUT NUMBER,
m_err_txt OUT VARCHAR2 )
IS BEGIN
m_err_no := 0;
SELECT e.employee_id, m.com_pager_no, m.sms_phone_no, s.sms_carrier_url,
e.email, SYS_CONTEXT( 'USERENV', 'IP_ADDRESS' ),
TO_CHAR( c.cache_ts, fmt_string ), c.ip_address
INTO m_employee_id, m_com_pager_no, m_sms_phone_no, m_sms_carrier_url,
m_email, m_ip_address, m_cache_ts, m_cache_addr
--FROM hr.v_emp_mobile_nos m, hr.v_employees_public e,
-- hr.v_sms_carrier_host s, v_two_fact_cd_cache c
FROM hr.v_emp_mobile_nos@orcl_link m, hr.v_employees_public@orcl_link e,
hr.v_sms_carrier_host@orcl_link s , v_two_fact_cd_cache c
Create Java Structures
Open each of these files and execute them on the apver instance from a SQL client. For each of the .java
files, uncomment the top line with the SQL CREATE OR REPLACE AND RESOLVE JAVA SOURCE statement, and
for OracleJavaSecure.java , edit the domain, SMTP host and base URL members, as before. Execute each
of these to create the Java structures in the apver instance. Be sure to substitute values for domains and
hostnames appropriate to your corporate environment into the OracleJavaSecure.java before creating
the Java structures in Oracle.
Chapter11/orajavsec/OracleJavaSecure.java
Chapter11/orajavsec/RevLvlClassIntfc.java
Chapter11/orajavsec/OJSC.java
Chapter11/testojs/TestOracleJavaSecure.sql
Remove Application Verification from the ORCL Instance
At this point, we no longer need application verification in the ORCL instance. We will disable
connections by the application verification, appver user to ORCL . Do that from a SQL client connection to
ORCL instance as appsec or SYS user with the following command.
 Note This is to be done on the ORCL instance only, and only if you are installing a second database instance,
apver , to do application verification.
ALTER USER appver PASSWORD EXPIRE;