Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Retrieving remote user without owa package. Is it possible ?
Retrieving remote user without owa package. Is it possible ? [message #246511] Thu, 21 June 2007 03:21 Go to next message
fmarchioni
Messages: 3
Registered: June 2007
Junior Member
Hi all,
is it possible to retrieve the REMOTE USER attribute from PL_SQL without using the OWA package ?

I explain myself: we are replacing Oas with a Plain Apache Web Server solution + MOD_PL_SQL for Apache.

Unfortunately OWA_UTIL functions seems not to work without Oas (There's a OWA module package which can be loaded too on apache, but it seems that mapping request to OWA modules excludes MOD_PL_SQL module......)

How can I "pull out" this information from PL-SQL ??

---- Possible solution ------------------------------
One Apache-expert suggested me that I let Apache rewrite the URL appending the user information

f.e.
http://localhost/plsql/PROCEDURE
--->
http://localhost/plsql/PROCEDURE?user=remoteuser

but then how can I read the url parameters without OWA ?

Please help to find a solution........
Thanks
Laura
Re: Retrieving remote user without owa package. Is it possible ? [message #247359 is a reply to message #246511] Mon, 25 June 2007 12:11 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Before you replace OAS with Apache - I assume you know that OHS (Oracle HTTP server) is a trimmed down OAS/iAS and as far as I know is already licensed as part of the database license. See some references in here...
http://www.theheat.dk/oracle/odtug2007/Lorenzen.doc


The environment variables you have access to in pl/sql are all set by the pl/sql gateway, which it gets from the web/app server. Some of that information comes from the web/app server directly (IP address I assume) and other info is provided by the browser (browser type identification etc). pl/sql can't tell you "anything" about the remote user unless the gateway provides it.

Any gateway not providing the environment info would be next to useless - so I assume it must be available.
http://www.sharemation.com/~dmcmahon/modowa.htm
http://unix.freshmeat.net/projects/mod_plsql
Previous Topic: Download location of htmldb 2.0 & Oracle Http Server
Next Topic: application import/export failing, hopefully a simple one though
Goto Forum:
  


Current Time: Thu Mar 28 10:29:46 CDT 2024