Block db access by IP and username
From: Aragon, Gabriel (GE, Corporate, consultant) <"Aragon,>
Date: Mon, 31 Aug 2009 15:53:25 -0400
Message-ID: <5409709395C6884598ADE701EDED9ACD2D0200_at_CINMLVEM17.e2k.ad.ge.com>
Hi all,
Date: Mon, 31 Aug 2009 15:53:25 -0400
Message-ID: <5409709395C6884598ADE701EDED9ACD2D0200_at_CINMLVEM17.e2k.ad.ge.com>
Hi all,
long time no checking this list. I have a security question. I need to block access to db by IP and username, let's say that I need that user XXXX can connect ONLY from IP aaa.bbb.ccc.ddd, that is, if user XXXX wants to connect from another IP, access will be denied.
I was thinking about using an after logon trigger to detect username and IP and kill session if it doest fit with required values, but I think this is a little bit rude. The other option I verified was using sqlnet.ora configuration but this only filters by IP and I would have to add all posssible IP's but doesnt filter users, and this is not what I need.
Any ideas?
TIA
Gabriel
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 31 2009 - 14:53:25 CDT