Blocking IP Address from Logging on to Database Server?
July 20th, 2008 By tushar.chitnis
Can I block a particular IP address to prevent it from logging into an Oracle 9i server?
2 Responses to “Blocking IP Address from Logging on to Database Server?”
Leave a Reply
You must be logged in to post a comment.
July 20th, 2008 at 11:59 am
You can use TCP.EXCLUDED_NODES in the sqlnet.ora file on the server.
July 26th, 2008 at 10:48 am
One option would be to use a logon-trigger in combination with evaluating SYS_CONTEXT(’USERENV’,'IP_ADDRESS’).