1 Reply Latest reply on Jul 8, 2017 12:11 PM by Mahmoud_Rabie

Invoke APEX_UTIL.IS_LOGIN_PASSWORD_VALID from ORDS RESTful modules handlers

Mahmoud_Rabie Jul 8, 2017 3:20 AM

Hello Experts

Given:

- Hybrid Mobile Application exchange data securely with ORDS RESTful modules.

Goal:

- Manage users from Apex environment not by writing and securing custom table and custom authentication schemes.

- Invoke APEX_UTIL.IS_LOGIN_PASSWORD_VALID from ORDS RESTful modules handlers (GET, POST, PUT, DELETE).

Obstacle:

IS_LOGIN_PASSWORD_VALID Function

This function returns a Boolean result based on the validity of the password for a named user account in the current workspace. This function returns TRUE if the password matches and it returns FALSE if the password does not match.

ORDS Context != APEX context

I would appreciate any solution or workaround.

Regards

Mahmoud

1. Re: Invoke APEX_UTIL.IS_LOGIN_PASSWORD_VALID from ORDS RESTful modules handlers

Mahmoud_Rabie Jul 8, 2017 12:11 PM (in response to Mahmoud_Rabie)

Finally, found the solution in this nice article

https://gerardnico.com/wiki/apex/security_group

I hope the following function helps someone

create or replace FUNCTION  "IS_VALIDUSER"(
          p_workspace in VARCHAR2,
          in_username in VARCHAR2,
          in_password in VARCHAR2)
return NUMBER
is
  l_workspace_id      NUMBER;
begin
    l_workspace_id := apex_util.find_security_group_id (p_workspace => p_workspace);
    apex_util.set_security_group_id (p_security_group_id => l_workspace_id);
   
    if(APEX_UTIL.IS_LOGIN_PASSWORD_VALID(in_username,in_password) ) then
        return 1;
    else
        return 0;
    end if;
end;

Regards

Mahmoud