01 4:06 AM
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 lo
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
>
Joe,
I know that using OCM - Net8 Connection Manager has the features you
require.
I have not yet needed to do implement it although it was considered.
Features are
- control client access to target servers
- setup filters to permit/restrict access to a server based on
i server hostid (or IP addre
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 sessi
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 M
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 sh
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:
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