Re: Block db access by IP and username
- From: Rakesh Tikku <rakesh.tikku@xxxxxxxxx>
- To: gabriel.aragon@xxxxxx
- Date: Mon, 31 Aug 2009 13:07:07 -0700
Hi Gabriel,
check out Oracle Connection Manger. It provides much more flexible
options to secure access to you database.
Rakesh
On Mon, Aug 31, 2009 at 12:53 PM, Aragon, Gabriel (GE, Corporate,
consultant)<gabriel.aragon@xxxxxx> 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?
>
> TIA
> Gabriel
--
//www.freelists.org/webpage/oracle-l
Other related posts:
