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.