Home » RDBMS Server » Server Administration » Restricting Database by IP's
Restricting Database by IP's [message #203910] Thu, 16 November 2006 23:01
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear Sir!
i have read a document that we can restrict database access by using the following enteries in SQLNET.ORA file

TCP.EXCLUDED_NODES=(192.168.0.21)
TCP.VALIDNODE_CHECKING=yes

i have tried it out at 8.1.7 but unable to do so
is it applicable at 8.1.7?

i have also tried afterlogon trigger to restrict specific user from specific terminal

CREATE OR REPLACE TRIGGER afterlogon
AFTER LOGON on DATABASE
DECLARE
l_username varchar2(30) := 'SCOTT';
l_terminal varchar2(30) := 'pts/2';
BEGIN
IF (USER = l_username AND sys_context('userenv','Terminal') =
l_terminal )
then
RAISE_APPLICATION_ERROR
(-20001, 'You are not allowed to logon from this terminal!!!');
END IF;
END;
/


Can u help me in this regard Sir?
Previous Topic: SUSE 9 ES + ORACLE 10g problem with shutdown
Next Topic: How to create second database in single instance..
Goto Forum:
  


Current Time: Mon Dec 05 21:05:31 CST 2016

Total time taken to generate the page: 0.05416 seconds