Home » RDBMS Server » Networking and Gateways » controlling database access (db 10gr2)
controlling database access [message #483435] Mon, 22 November 2010 02:15 Go to next message
kamransagri
Messages: 13
Registered: May 2006
Location: india
Junior Member
hi,

i want to restrict particular ips ,for that i specified
TCP.VALIDNODE_CHECKING= YES
AND
TCP.INVITED_NODES=(IPADDRESS)

in sqlnet.ora file but whenever i connect to database from the particular specified IPADDRESS , the database allows the connection to happen ( doesnot restrict it),

kindly help me out.

thanks.
Re: controlling database access [message #483438 is a reply to message #483435] Mon, 22 November 2010 02:35 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Of course, you INVITED this address to connect.
If you want to EXCLUDE this address then use TCP.EXCLUDED_NODES.

Regards
Michel
Previous Topic: ORA-12505
Next Topic: Bind 1 Listener on 2 Interfaces
Goto Forum:
  


Current Time: Thu Mar 28 05:31:59 CDT 2024