See Also:For more information about implementation of this package:
The chapter contains the following topics:
Parameters that have default values are optional.
Returns the client's hostname
Returns the client's IP address
Returns the password that the user entered
Returns the username that the user entered
Enables the PL/SQL application to use custom authentication
Defines the realm that the page is in
This function returns the hostname of the client.
OWA_SEC.GET_CLIENT_HOSTNAME RETURN VARCHAR2;
This function returns the IP address of the client.
OWA_SEC.GET_CLIENT_IP RETURN OWA_UTIL.IP_ADDRESS;
The IP address. The
owa_util.ip_address data type is a PL/SQL table where the first four elements contain the four numbers of the IP address. For example, if the IP address is
220.127.116.11 and the variable
ipaddr is of the owa_util.ip_address data type, the variable would contain the following values:
ipaddr(1) = 123 ipaddr(2) = 45 ipaddr(3) = 67 ipaddr(4) = 89
This function returns the password that the user used to log in.
OWA_SEC.GET_PASSWORD RETURN VARCHAR2;
For security reasons, this function returns a true value only when custom authentication is used. If you call this function when you are not using custom authentication, the function returns an undefined value. Thus, the database passwords are not exposed.
This function returns the username that the user used to log in.
OWA_SEC.GET_USER_ID RETURN VARCHAR2;
This procedure, called in the initialization portion of the OWA_CUSTOM package, sets the authorization scheme for the PL/SQL Gateway. This implements your
authorize function, which authorizes the user before his requested procedure is run. The placement of the
authorize function depends on the scheme you select.
OWA_SEC.SET_AUTHORIZATION( scheme IN INTEGER);
The authorization scheme. It is one of the following schemes for
If the function returns
This procedure sets the realm of the page that is returned to the user. The user enters a username and login that already exist in the realm.
OWA_SEC.SET_PROTECTION_REALM( realm IN VARCHAR2);