killing a session based on host the user is logging on from

[andreasb]

Hi all,

I'm trying to add some additional security by doing the following:
1) create logon trigger
2) check the host the user is connecting from
3)kill the session, if the host is not in a predefined list of allowed hosts for that user

So far it doesn't seem to work

1 and 2 are easy, step 3 is the one I don't know
how to accomplish.
Did anyone implement something like that and if yes, how ?

thanks,

Andreas

[andreasb]

so far, the following was tried:

- create trigger after logon on database
- inside the trigger, call procedure to kill the session with
alter system kill session

THIS seems to be the main problem, since I'm getting ORA-00027, cannot kill current session

So the question is: Is there a way to disconnect/kill a session from within this session OR, how to create some sort of background process, which one needs to signal then somehow, to kill a named session ?