This discussion is archived
5 Replies Latest reply: Feb 25, 2013 6:58 AM by Patrick Wolf RSS

How to get Siteminder Username from HTTP request headers in APEX

vyuvaraj Newbie
Currently Being Moderated
We are using APEX 4.2on oracle 11.2.0.3 database. I've configured CA site-minder agent for single sign-on on an Apache web-server.

We are trying to get the username that will be passed in through the HTTP request headers.

I am using OWA_UTIL.PRINT_CGI_ENV(); to get the environment variables, but SSO information does not exist.
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 = 8081
SERVER_NAME = XDB HTTP Server
REQUEST_METHOD = GET
QUERY_STRING = p=113:1:
PATH_INFO = /f
SCRIPT_NAME = /apex
REMOTE_HOST =
REMOTE_ADDR = 139.149.48.150
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 5.1; rv:13.0) Gecko/20100101 Firefox/13.0.1
HTTP_HOST = xldn4750vdor.ldn.swissbank.com:8081
HTTP_ACCEPT = text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING = gzip,deflate
HTTP_ACCEPT_LANGUAGE = en-us,en;q=0.5
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_COOKIE = GDSESSION=DCGMAP8g5AMfjpnAc3PTm7p9QhBHm7P+
Can someone provide me with directions on how to do this? I have been struggling to find out how to exactly do this.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points