| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/pubsec.sql
{ORACLE_HOME}/rdbms/admin/privtext.sql |
| First Availability |
8.1.7 |
| Constants |
| Name |
Data Type |
Value |
| CUSTOM |
INTEGER |
4 |
| GLOBAL |
INTEGER |
2 |
| NO_CHECK |
INTEGER |
1 |
| PER_PACKAGE |
INTEGER |
3 |
|
| Dependencies |
| OWA |
OWA_CUSTOM |
OWA_CX |
OWA_UTIL |
|
| Security Model |
Owned by SYS with no privs granted |
| Subprograms |
|
| |
| 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; |
