Re: Trigger force a logout?

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Thu, 25 Jun 2009 09:44:44 -0500
Message-ID: <de807caa0906250744i69fe76ffw1c2c4001ac0edc92_at_mail.gmail.com>



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_at_yahoo.com> 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_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-l
Received on Thu Jun 25 2009 - 09:44:44 CDT

Original text of this message