| 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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
