Re: Limiting connections to a single schema

tldry_at_charter.net (Tim Dry) wrote in message news:<fad761ad.0210101445.60efbea3_at_posting.google.com>...
> Is there any way for a listener to be limited as to what accounts can
> be accesed through it? I have a database that is used by multiple
> internal applications and I now have a need to allow access to the
> database for an additional application that will run outside of the
> firewall. If I could create a new listener on a new port that could
> only access this new schema/application, then I could limit my
> exposure a little. Thanks in advance for any recommendations.
>
> -Tim Dry

A better method would be setting up Connection Manager, a net8i module. In 8.0 and before you can create protocol.ora and set tcp.invited_nodes

Hth

Sybrand Bakker
Senior Oracle DBA Received on Fri Oct 11 2002 - 09:33:20 CEST