security - Securely connecting to database within a application -
I have never developed an application outside of my company system, where we just rely on Windows certification from our domain , But I want to learn how to develop a secure application that I can connect to a remote database
I know that if I use ASP then it is easy because the data connection server Will be on the side, but I also have to apply a WPF application for administrative tasks.
What can I think to connect securely to a database here:
First of all there is always an SSL connection to the database, a default user is / near Clear text is the config file of the program, where it is only for logging process on the login database, where the user enters the database credentials there and the default user will be connected to the nearest DB and the sub Will have the credentials presented by Ogkrta.
The process will then return / pass the pair of credentials to the user that the session will be used in the session for the user's remaining account. Is there a good way to reach this issue? And should I consider using the web service as the interface rather than the direct service of WCF?
Why complicated? Just enter the database user name and password to the user and then try connecting to the server using an SSL connection. The server already has a full featured user management system, so you need access to some people, so there is no need to create a new one.
Comments
Post a Comment