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..'