Re: Block db access by IP and username

From: Balakrishna Y <>
Date: Mon, 31 Aug 2009 22:41:28 -0700
Message-ID: <>


Check this too

Use should also set TCP.VALIDNODE_CHECKING in order to work properly .



On Mon, Aug 31, 2009 at 12:53 PM, Aragon, Gabriel (GE, Corporate, consultant) <> wrote:

> 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?
> Gabriel

Received on Tue Sep 01 2009 - 00:41:28 CDT

Original text of this message