Database Networking (MOSC)

MOSC Banner

Restricting DB access to only "localhost" connections

edited Oct 29, 2015 10:13AM in Database Networking (MOSC) 1 commentAnswered

I need to restrict all access to a database except for applications on the server on which the database exists.

I can't simply disable the listener, as it is used by the JDBC client even to connect locally.

I also cannot use a Logon Trigger, as I need to keep even SYS and SYSTEM from being able to log in if it is not from the local box.

Is there some way I can do this either via the listener or via some database system mechanism?

Thanks for any help,

-- Mark

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center