Re: Trigger force a logout?

  • From: Joey D'Antoni <jdanton1@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 25 Jun 2009 07:30:12 -0700 (PDT)

What would your conditions be?--this can be tricky. For example, if you try to 
block access from certain programs (e.g. sqlplus.exe) for non-system users, the 
program name can be spoofed.

But yes, this can be done.

Joseph D'Antoni
Synthes USA




________________________________
From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
To: oracledba.williams@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Thursday, June 25, 2009 10:25:11 AM
Subject: Re: Trigger force a logout?

yes, it is possible.  It would be a system trigger.


On Thu, Jun 25, 2009 at 9:15 AM, Dennis Williams <oracledba.williams@xxxxxxxxx> 
wrote:

List,
>
>To plug a security gap, I'm trying to create a trigger on a certain username. 
>If the trigger condition is met, the trigger would force a logout. Is that 
>possible?
>
>Thanks for any suggestions,
>Dennis Williams


-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving..'



      

Other related posts: