Re: Forms user session restrictions

From: LS Cheng <exriscer_at_gmail.com>
Date: Wed, 30 Nov 2011 10:35:14 +0100
Message-ID: <CAJ2-Qb-ES-HLGGbP6Fr29yWDwLcGYdT1P+73FbGXYvJkqbOmHA_at_mail.gmail.com>

Hi
Since user terminal in Forms Server is really the machine where Forms Server is running you would probably need to do this:

1. Use webutil to get each PC's IP, machine, OSUSER etc.
2. Create a context inside the database which calls a verification package (or instead of context use a logon trigger)
3. This package will verify if the connected database user is connected more than once from the same PC (by using the info you gather in step 1), if the new connection is from another PC or IP or OSUSER then just raise an error and exit database
4. If you want to go hardcore security you can create a table which maps database user to a static IP and force each user can only logon from that IP when using Forms

Regards

--

LSC
--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 30 2011 - 03:35:14 CST