What about the old protocol.ora?
-Original Message-
From: Vadim Gorbounov [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 20:17
To: Multiple recipients of list ORACLE-L
Subject: RE: restrict login with known IP address
Hello, Joseph
Try something like this
CREATE
To: Multiple recipients of list ORACLE-L
What about the old protocol.ora?
-Original Message-
From: Vadim Gorbounov [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 20:17
To: Multiple recipients of list ORACLE-L
Subject: RE: restrict login with known IP address
Hello
Title: RE: restrict login with known IP address
use the
tcp.invited_nodes
paramter in a protocol.ora file (.protocol.ora if you
are on 8.1.6 due)
R. Matt Adams - GE Appliances - [EMAIL PROTECTED]
Meddle not in the affairs of troff,
for it is subtle and quick to anger
Yes, it is possible thorugh protocol.ora. Practically, you must configure the
excluded IP addresses using excluded nodes option.
Regards,
Pierre
-Original Message-
From: LeydenJ [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 7:26 PM
To: ORACLE-L
Cc: LeydenJ
Subject:
Hi Joe,
What version of Oracle do you use?
In 815 and upstair you can use logon trigger.
Inside the trigger try to determine IP address of
the current session using the following sikvel:
select sys_context('USERENV', 'IP_ADDRESS') from dual;
I haven't tryed this policy yet but I believe it
Hello, Joseph
Try something like this
CREATE OR REPLACE TRIGGER IP_CATCH AFTER LOGON ON DATABASE
BEGIN
if ora_client_ip_address = '172.16.0.175' then
raise_application_error(-20001, 'No way from '||ora_client_ip_address);
end if;
END;
/
HTH
Vadim Gorbounov
Oracle DBA
-Original
I'm using 8.0.5
am I hopeless?
-Original Message-
Sent: Tuesday, May 08, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L
Hi Joe,
What version of Oracle do you use?
In 815 and upstair you can use logon trigger.
Inside the trigger try to determine IP address of
the current
