Hi all,
I'm working on an Oracle APEX application where I need to identify each user who connects to the app, even if they are on the same network (like in an office).
Right now, I’m using this code:
select owa_util.get_cgi_env('REMOTE_ADDR') into l_remote_addr from dual;
This only returns the public IP address (the router's IP), not the individual device IPs like 192.168.x.x. So, if multiple users are in the same office, they all appear with the same IP.
I want to track each user or device separately, not just by the shared public IP.
Any simple solution or workaround would be appreciated.
thanks.