RE: Disconnecting session from an on logon trigger

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

If you want to restrict all or most users based on time, the simplest way to do that is to enable/disable oracle restricted session, and only grant the restricted session privilege to those whom you want to allow to log in.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jay.Miller_at_tdameritrade.com
Sent: Friday, October 12, 2007 3:42 PM
To: oracle-l_at_freelists.org
Subject: Disconnecting session from an on logon trigger

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

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:06:13 CDT