Re: Trigger force a logout?
From: Joey D'Antoni <jdanton1_at_yahoo.com>
Date: Thu, 25 Jun 2009 07:30:12 -0700 (PDT)
Message-ID: <768689.76840.qm_at_web58701.mail.re1.yahoo.com>
Date: Thu, 25 Jun 2009 07:30:12 -0700 (PDT)
Message-ID: <768689.76840.qm_at_web58701.mail.re1.yahoo.com>
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_at_gmail.com>
To: oracledba.williams_at_gmail.com
Cc: oracle-l_at_freelists.org
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_at_gmail.com> 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..'
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 25 2009 - 09:30:12 CDT