RE: Disconnecting session from an on logon trigger
- From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
- To: Jay.Miller@xxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 15 Oct 2007 08:06:13 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Jay.Miller@xxxxxxxxxxxxxxxx
Sent: Friday, October 12, 2007 3:42 PM
To: oracle-l@xxxxxxxxxxxxx
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.
==============================================================================
Other related posts:
