Question:
In a web application, we want to obtain the client user name. For example, a user with
user name "tomid" to log in to his window machine and open a browser to access the
web application, how can we obtain the "tomid" in the web application?
Environmnet: using mod_plsql in OAS10g, the application is written by package/procedure in pl/sql.
The method I have tried:
1) using owa_util.get_cgi_env('REMOTE_USER'), this one alway return the schema name but not the client name.
2) using sys_context and return empty everytime.
3) If we add a line: PlsqlCGIEnvironmentList REMOTE_USER=testuser in DAD string, the function owa_util.get_cig_env('REMOTE_USER') will return 'testuser'
Any idea how to obtain the user name in the package/procedure; or how to set the oracle
web server so that owa_util.get_cgi_env('REMOTE_USER") can return the user name.
Thank you so much!

SELECT SYS_CONTEXT('USERENV','OS_USER') FROM DUAL;

查看v$session试试

Thanks atgc.
But it returns nothing. I guess it makes sense because sys_context does not run in the same space as the package.  
I think the OWS security setting prevent the owa_util.get_cig_env('REMOTE_USER') from obtaining the right client user name. We are using OAS basic authentication in the DAD string. But I do not know how to make it work.
Somebody has the similar experience before? Thanks. (My apology not using Chinese here due to the lack of chinese input
in my computer, sorry again)

Thanks junsansi
I don't think v$session can give the right answer.

It looks that basic authentication mode in mod_plsql without requiring end user to log in makes the REMOTE_USER point to the wrong
os_user (it points to database user set in DAD string); However, if I set the authentication mode to others such as global owa or custom owa, it will require the end user to log in with user name and password.  
At present, my question is: how to set up the authentication mode in mod_plsql so that the package/procedure can get the OS_USER name
while the end user does not need to log in to the web page ( it means no log in dialog box poped out when the user open the web page)
Anyone interested in the topic, we can go on discussing. Thanks.

Here is what I read from Metalink:

From: Anton Els 18-Dec-02 09:41
Subject: Re : How to get OS Username from Web Page via PLSQL WEB Toolkit


I am still sitting with the same problem. I want to use BASIC Authentication not having User login screens etc. I would like the user to connect to the application without entering any userid or passwords, and then let the application lookup the user in a user table to get the specific application authorizatoin needed by the user, which will then allow certain options to the user in the WEB app. This user section will be maintained by a different application.

But, if the user login via the WEB to the Application, the OS USER name is the "NT AUTHORITYSYSTEM" user, which is not what I am looking for (I think it picks up the userid that apache is running under) , I need the actual OS USERID of that specific user. I have looked at the sys_context options but it only brings back the same info or the Database user id. Is there any other way of doing this without making use of a actual login screen where the user need to type in a userid and password? Is there any html, or javascript options I can use to get this userid?





--------------------------------------------------------------------------------

From: Oracle, Ken Vincent 26-Dec-02 17:50
Subject: Re : Re : How to get OS Username from Web Page via PLSQL WEB Toolkit


Anton,

There isn't a way within the PL/SQL Tookit. There used to be a nt authentication feature in the older webserver versions, but it was not very reliable, as different circumstances beyond anyone's control can block the info from being obtained.

In order to use REMOTE_USER, you still need to have some sort of authentication occur within the HTTP Server in order for the PL/SQL Tookit to use it.




Ken Vincent
Internet Products Support

Ok, the problem can be solved by WNA (windows Native Authentication) together with SSO (single sign on).
Here is the link useful for those who might have the same problem:
http://download-uk.oracle.com/do ... b13791/kerberos.htm