Hi all,
please, is there any (reasonably simple and straightforward) way how to get currently logged in Windows username without installing any other software? I've googled a lot and also searched this forum back and forth with no success. Formerly I used to get the OS username with a Java applet that was able to read user's credentials (uploaded into static files) but it became really annoying after the new security restrictions (signing applets) that came with Java 7xx (exact version number is not really important). I also found here in posts that it should be somehow possible to read the CGI variable REMOTE_USER (or whatever), but my REMOTE_USER is always ANONYMOUS. In this
post is mentioned that it should be possible after editing http.conf or dads.conf, but there are no such files in embedded plsql gateway.
So please, if anyone has an idea how to get that damn windows username into the browser, I would be very grateful.
Thanks a lot,
Pavel
owa_util.print_cgi_env;
PLSQL_GATEWAY = WebDb
GATEWAY_IVERSION = 2
SERVER_SOFTWARE = Oracle Embedded PL/SQL Gateway/11.2.0.2.0
GATEWAY_INTERFACE = CGI/1.1
SERVER_PORT = 8090
SERVER_NAME = XDB HTTP Server
REQUEST_METHOD = GET
QUERY_STRING = p=116:1:4730123570197
PATH_INFO = /f
SCRIPT_NAME = /apex
REMOTE_HOST =
REMOTE_ADDR = xx.24.68.xx
SERVER_PROTOCOL = HTTP/1.1
REQUEST_PROTOCOL = HTTP
REMOTE_USER = ANONYMOUS
ORACLE_SSO_USER =
HTTP_CONTENT_LENGTH = 0
HTTP_CONTENT_TYPE =
HTTP_USER_AGENT = Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Firefox/31.0
HTTP_HOST = xx.220.197.xx
HTTP_ACCEPT = text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING = gzip,deflate
HTTP_ACCEPT_LANGUAGE = cs,en-us;q=0.7,en;q=0.3
HTTP_REFERER = http://213.220.197.162/apex/f?p=4000:1500:4730123570197:::::
WEB_AUTHENT_PREFIX =
DAD_NAME = apex
DOC_ACCESS_PATH = docs
DOCUMENT_TABLE = wwv_flow_file_objects$
PATH_ALIAS =
REQUEST_CHARSET = AL32UTF8
REQUEST_IANA_CHARSET = UTF-8
SCRIPT_PREFIX =
HTTP_SMUSER =
HTTP_COOKIE = ORA_WWV_ATTRIBUTE_PAGE=4311%2C%23ALL; ORA_WWV_F4000_P4150_TREE=RenderingTree%3A2393424833662564_page_items%3A2395603733662589; LOGIN_USERNAME_COOKIE=testuser