Jump to content

Database connection only by a specific user

Recommended Posts


There are secure ways to guarantee that only a specific user schema connection can be done from a client machine to a database? Wich are they?

Thank you so much.

Best regards,


Share this post

Link to post
Share on other sites

Hi Hugo, and welcome to the forum!

There are several ways to do this, techniques like creating a separate listener, and making the client sqlnet.ora point to that listener.


An easier way to do this is to use a logon trigger:


Good luck!

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now