The company I work for is developing a new web-site (PHP I suppose), and the login to the apex appliciation should be integrated with this site, i.e. on this page there should be a >login-region complete with username/password/login-button which forwards to apex. Any ideas?
Another thing mentioned in your whitepaper is passing username and password via a custom cookie. Is it possible to set a cookie to enable automatic login to APEX? How can I >achieve this?When user enters username and password, then these details you can send to APEX via a cookie. You can create custom cookie using [url http://www.dba-oracle.com/t_easy_html_db_owa_cookie.htm]OWA_COOKIE package. And make sure you [url http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_crypto.htm#i1002112]Encrypt both the username and password.
Currently I'm using "Application Express Accounts" and I would like to keep it that way, meaning I would like to leave the user management to APEX.You can still use APEX Authentication Scheme. The moment user clicks on login page in your php application.. then
I have not tested this. But this should work. Please update how it goes.
/* This is psuedo code */ :P101_USERNAME := get_decrypted_username_from_cookie; IF :P101_USERNAME IS NOT NULL THEN -- coming from PHP application :P101_PASSWORD := get_decrypted_password_from_cookie; /* Call APEX Log-in Procedure */ APEX_CUSTOM_AUTH.login( P_UNAME => :P101_USERNAME, P_PASSWORD => :P101_PASSWORD, P_SESSION_ID => v('APP_SESSION'), P_APP_PAGE => :APP_ID||':1' ); END IF;