Re: Forms user session restrictions

  • From: LS Cheng <exriscer@xxxxxxxxx>
  • To: ivanrs79@xxxxxxxxx
  • Date: Wed, 30 Nov 2011 10:35:14 +0100

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


--
//www.freelists.org/webpage/oracle-l


Other related posts: