Jump to content
hugo.cardoso

Database connection only by a specific user

Recommended Posts

Hi,

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,
Hugo.

 

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.

http://www.dba-oracle.com/t_configure_multiple_listeners.htm

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

http://www.dba-oracle.com/art_builder_sec_audit.htm

Good luck!

Share this post


Link to post
Share on other sites

Hi Hugo,

A simple sution would be to revoke the “connec”, “resource”, and “create session” roles from all users except the one that you want to connect.

Let us know if this works for you.

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

×