RE: Disconnecting session from an on logon trigger

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Mon, 15 Oct 2007 08:04:54 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB3097A8D55@x6009a.umb.corp.umb.com>

You might look at enabling and disabling restricted session.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of sol beach Sent: Friday, October 12, 2007 5:16 PM
To: roman.podshivalov_at_gmail.com
Cc: Jay.Miller_at_tdameritrade.com; oracle-l_at_freelists.org Subject: Re: Disconnecting session from an on logon trigger

see this thread

http://www.orafaq.com/forum/m/270601/74940/?srch=logon+trigger#msg_27060 1

Exactly what are the "certain circumstances"?

I suspect the desired solution is a case where it is the wrong tool for this job

On 10/12/07, Roman Podshivalov <roman.podshivalov_at_gmail.com> wrote:

What about just locking the user if conditions are met ?

--romas

On 10/12/07, Jay.Miller_at_tdameritrade.com <Jay.Miller_at_tdameritrade.com > wrote:

I'd like to create an on logon trigger that will prevent the user from connecting in certain circumstances. I have one way of doing it which would be to issue

execute immediate ' alter system kill session 'session_id', 'serial#''

but I can't help but wonder if there's a cleaner way to do it from within oracle instead of killing the session?

Oracle 9.2.0.7 <http://9.2.0.7/>

Thanks,
Jay Miller

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 15 2007 - 08:04:54 CDT