I want to store and retrieve users added to sql database using c#(Winforms) . When a user logs in to the application (C#), controls will be enabled/disabled/visible/hidden based on the role that the user has been added to and, logs will be stored when the user accesses a stored procedure, view or functions. My question is: Do I need to create a database user(sql database user) for each user name (using a single login name)
when the user of the c# application add a new user or do i create a database table and add users to it (using single login name and user name to sql database and server)?
What I have tried:
i do not know which option is suitable.