Re: Access based on IP Address and Username

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Nov 2006 06:30:55 -0800
Message-ID: <1163169055.481105.286490@b28g2000cwb.googlegroups.com>

On Nov 10, 9:26 am, "Mark D Powell" <Mark.Pow..._at_eds.com> wrote:
> 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,
> > RajSee 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 --

I apologize as I misread your post. What you want for your problem description is to code a database event logon trigger to test the Oracle username verse allowed IP addresses. See the Concepts manual and then the SQL manual.

HTH -- Mark D Powell -- Received on Fri Nov 10 2006 - 08:30:55 CST