Re: restrict user IP on Oracle server

From: Steve <smontgomerie_at_hotmail.com>
Date: 13 Aug 2002 12:22:34 -0700
Message-ID: <156709aa.0208131122.36c2479c@posting.google.com>

you might consider the 'Enhanced Virtual Private Database' feature of 9i.

Here's a sample

CREATE ROLE app_user
IDENTIFIED USING steve.check_user;

CREATE OR REPLACE PROCEDURE check_user
AUTHID CURRENT USER IS
ipchk STRING(30)
BEGIN
  SELECT SYS_CONTEXT('USERENV','IP_ADDRESS')   INTO ipchk FROM DUAL;
  IF SUBSTR(ipchk,1,4) != '192.'
  THEN RETURN; END IF;
  DBMS_SESSION.SET_ROLE('APP_USER');
END;
/

search on the following for more info

Secure Application Role
SYS_CONTEXT good luck

steve

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3D57D60C.C959B5EB_at_exesolutions.com>...
> srivenu wrote:
>
> > From Oracle 9i
> >
> > The protocol.ora file is no longer supported.
> >
> > Parameters in the protocol.ora file have been merged into the sqlnet.ora file.
>
> You are correct. I should have noted the comment related to 8i.
>
> Daniel Morgan
Received on Tue Aug 13 2002 - 14:22:34 CDT