Kbase P101541: How to block remote connections to a database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/3/2006 |
|
Status: Unverified
GOAL:
How to block remote connections to a database.
GOAL:
How to disable remote logins to a database.
FIX:
There are a few options:
1. Don't start the database using the -S and -H database startup parameters. These parameters denote the service name
umber and hostname that remote connections (connections from a different machine) will use. You will also need to ensure that host-based users (users that run on the same machine as the database) connect to the database without using the -S and -H database startup parameters.
2. Use a firewall to restrict the IP addresses that can connect to the database's port number on that machine. This could be very difficult to maintain and could be relatively easy for somebody to workaround if they knew the IP range that worked, and the database port number.
3. Implement database security. Users would need to be added to the database and therefore would require them to log in during each connection. The user login requirement would apply to all users both local and remote.