CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle OWA_SEC
Version 11.1
 
General Information
Source {ORACLE_HOME}/rdbms/admin/pubsec.sql
{ORACLE_HOME}/rdbms/admin/privtext.sql
First Availability
Name Data Type Value
CUSTOM INTEGER 4
GLOBAL INTEGER 2
NO_CHECK INTEGER 1
PER_PACKAGE INTEGER 3
Constants 8.1.7
Dependencies
HTP OWA_PATTERN
 
GET_CLIENT_HOSTNAME
Obtains the Web client's Host Name owa_sec.get_client_hostname RETURN VARCHAR2;
Calls owa.hostname
 
GET_CLIENT_IP
Obtains the Web client's IP Address owa_sec.get_client_ip RETURN owa_util.ip_address;
Calls owa.ip_address

If address is 192.168.1.118 then
ip_address(1) = 192
ip_address(2) = 169
ip_address(3) =   1
ip_address(4) = 118


set serveroutput on

DECLARE
 iparray owa_util.ip_address;
BEGIN
  iparray := owa_sec.get_client_ip;
  dbms_output.put_line(iparray(1));
  dbms_output.put_line(iparray(2));
  dbms_output.put_line(iparray(3));
  dbms_output.put_line(iparray(4));
END;
/
 
GET_PASSWORD
Obtains the Web client's password owa_sec.get_password RETURN VARCHAR2;
Calls owa.password
 
GET_USER_ID
Obtain the Web client's authentication user identifier owa_sec.get_user_id RETURN owa.user_id;
Calls owa_user_id
 
SET_AUTHORIZATION
Specifies the PL/SQL Agent's authorization scheme  owa_sec.set_authorization(scheme IN INTEGER);
See OWA_CUSTOM package Initialization Section (link below)
 
SET_PROTECTION_REALM
Specifies the dynamic page's protection real owa_sec.set_protection_realm(realm IN VARCHAR2);
-- source code
BEGIN
  owa.protection_realm := realm;
END;
 
Related Topics
OWA
OWA_CUSTOM
OWA_CX
OWA_OPT_LOCK
OWA_TEXT
OWA_UTIL
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [186 users online]    © 2010 psoug.org