0

I have a simple logic question which I don't understand for now. I am currently working on a simple winforms application which should allow users to register and login to a database (SQL Server database). That users should be able to, for example, buy something. Now I wonder If I need to create a database user which is allowed to modify that record to change their data or if there is another possibility to do that. I think most people create a table which stores all users and their information but how do they connect to the database if they are not a database user? Im a bit confused and I am pretty new to databases.

Thomas5897
  • 61
  • 2
  • 9
  • 1
    Your application has a login/user; not the person using the application. – Thom A Apr 30 '18 at 08:53
  • 1
    https://stackoverflow.com/questions/341271/should-application-users-be-database-users – Tassadaque Apr 30 '18 at 08:55
  • 1
    I recommend creating a database user for the application itself, so you can manage the privileges of that user and users register to you application using application log-ins but all database modifications go through the application DB account. If that makes sense? – WhatsThePoint Apr 30 '18 at 08:57
  • @WhatsThePoint Ah okay I understand. But when I login as administrator I want a different behavior. For example the administrator should be able to delete users and he should also be able to do that within the application. – Thomas5897 Apr 30 '18 at 09:07

0 Answers0