Checking client signon on the host

I've been asked to tighten security in our application by writing a procedure that checks who has signed onto the client. Because our application was set up with Forte, the users sign on to a remote system under their own IDs but when they utilize the server, they all are under the one ID used by Forte. What I want to do is have this Forte user default to a limited profile which can only invoke the checking routine. If that determines that the client signon is valid (right person, right machine), then a password protected role will be activated for the user ID.

The problem I'm having is obtaining information about the invoker. With the following query,

     select machine from v$session where audsid = userenv('SESSIONID') I can determine where the machine that sent the request to the host but still do not have an idea how to determine the original user ID. Any thoughts or suggestions would be appreciated.

TIA
Cory Brooks Received on Thu Nov 05 1998 - 12:13:53 CST