Re: Connect to Oracle Server from specific Client machin(whose ip is mention in server)

You could also use the "valid nodes" feature of Oracle Net to only allow access from one IP address. The documentation should explain how to set it.

                                    Rick

Martin Haltmayer <Martin.Haltmayer_at_d2mail.de> writes:

> Hi Sachin,
>
> you could give them one schema that is controlled by a profile only allowing one
> session at a time. Or do they have to work as different Oracle users?
>
> Regards,
>
> Martin
>
>
>
> Sachin wrote:
> >
> > My problem is that I want my Oracle server to be accessed by
> > some specific clients. Say, I am having one Oracle Server and five
> > Oracle Clients in network. Until now all clients are having access on
> > that Server. But from security point of view, now I want my Oracle
> > Server
> > to be accessed by only one client. Everyone is having access
> > permission on all client machin.
> > But without me no one is having permission to work on Oracle Server.
> > My problem is that I want only one client machin can access my
> > Server. Is their any configuration file on my server, where I can
> > specify IP of
> > that client machin, from where I want to give access to my server. I
> > just
> > want to Specify from which IP my server should be accessed. Please
> > help
> > me.
>
>

-- 
                                Rick Wessman
                                Security Assurance Group
                                Oracle Corporation
                                Rick.Wessman_at_oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.