Hello All,
Anyone please help with this request. I want to have a login page for the application where in users just enter their login user id and just click login button; once they login; i have an authorization process which checks against database table for their user id and redirects to different pages based on their role defined in the database. If its an invalid user id; the process redirects to non-authorized page.
Is it possible in oracle apex to login to application with just their user id. We are using Oracle APEX 4.0.2 version and oracle 10g r2 database.
Previously, we used to have LDAP authentication which was non-ssl and we don't want to use it, as the company policy won't allow this. We tried setting up SSL connection and creating oracle certificate with the help of DBA but this still takes some time.
DECLARE
v_role VARCHAR2 (30);
v_page NUMBER;
BEGIN
BEGIN
SELECT user_role
INTO v_role
FROM table_a
WHERE USER_ID = UPPER (TRIM (:P101_USERNAME));
EXCEPTION WHEN NO_DATA_FOUND THEN
v_role := NULL;
END;
IF v_role = 'MANAGER' OR v_role = 'DIRECTOR'
THEN
v_page := 1;
ELSIF v_role = 'ANALYST'
THEN
v_page := 32;
ELSE
v_page := 200;
END IF;
APEX_UTIL.set_session_state (p_name => 'FSP_AFTER_LOGIN_URL', p_value => NULL);
wwv_flow_custom_auth_std.login (P_UNAME => :P101_USERNAME,
P_PASSWORD => :P101_PASSWORD,
P_SESSION_ID => v ('APP_SESSION'),
P_FLOW_PAGE => :APP_ID || ':' || v_page);
END;
How to modify, the above process to allow null value for the password field.
Please help with possible suggestions. Thanks in advance.
Thanks,
Orton