Re: Access based on IP Address and Username

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Nov 2006 06:26:53 -0800
Message-ID: <1163168813.296496.325670@i42g2000cwa.googlegroups.com>

On Nov 10, 8:48 am, "rsp..._at_gmail.com" <rsp..._at_gmail.com> wrote:
> We are trying to restrict access to the database depending on a
> combination of accessing machine's ip address and oracle username eg.
> user jack should be allowed to access only from the ip address
> 10.0.11.72 and not from any other ip address? Is this possible?
>
> Thanks in Advance for the Help.
>
> Regards,
> Raj

See the section labeled Configuring Database Access Control in the in chaper 11, Configuring Profiles, in the Oracle9i Net Services Administrator's Guide Release 2 (9.2) Part Number A96580-02 manual for TCP.VALIDNODE_CHECKING. HTH -- Mark D Powell -- Received on Fri Nov 10 2006 - 08:26:53 CST