title: How to handle database users in asp.net c#
body: <p>I am making a website in asp.net. In my application, I divided the users into two categories. One is normal users and other is admin users. Admin users will be probably one or maximum two users. I decided to create separate two database users for admin users rather than table users in SQL server. So I have three database users two for admin and one for normal users  </p>
  
  <p>Case 1:
  Scenario is that if normal user want to login. System will connect to normal database user in SQL SERVER and will look the credentials in users table. If it found the user then session will generate and normal user will redirect to welcome page.</p>
  
  <p>Case 2:
  For admin users I have direct database user. I am not storing and looking admin users in users table. Admin user can be dynamic. I don’t want to save database user in connection string in  web.config file for admin. Connection always be runtime but the problem is how to handle database users credentials because I don’t want to store database user credentials in cookies and session.</p>
  
  <p>Suppose if admin usr 1 login through login page. My system will check either that database user exist in SQL SERVER or not. If exist system will redirect to welcome page and I want my whole application remember admin usr 1 is logged in. </p>
  
  <p>How to handle this scenario in asp.net.</p>