Joe, Agreed, not bullet-proof, but hopefully much better than the current situation. Dennis On Thu, Jun 25, 2009 at 9:30 AM, Joey D'Antoni <jdanton1@xxxxxxxxx> wrote: > 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.' > >