|Restricting Database by IP's [message #203910]
||Thu, 16 November 2006 23:01
Registered: September 2006
i have read a document that we can restrict database access by using the following enteries in SQLNET.ORA file
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
l_username varchar2(30) := 'SCOTT';
l_terminal varchar2(30) := 'pts/2';
IF (USER = l_username AND sys_context('userenv','Terminal') =
(-20001, 'You are not allowed to logon from this terminal!!!');
Can u help me in this regard Sir?