creating multiple users for a c#.net winform application using sql server express <p>i have a single sql database in sql server express.</p> <p>i have a login MAINLOGIN, for this database.</p> <p>i want insertion of data in this database through multiple users, U1,U2,U3, each having different userids &amp; passwords. </p> <p>These users would be created by MAINLOGIN , manually or via the winform application.</p> <p>So while creating MAINLOGIN , i would give him permission to further create logins.</p> <p>For this what should i do?</p> <p>i cannot create MULTIPLE users, because for one database, only one user can be created under one login.</p> <p>so should i create multiple logins, L1,L2,L3, then map, U1, U2, U3 to them.</p> <p>Or, is there a better way to do this? like application roles etc. </p> <p>i dont want to use windows authentication. because if i know the system password, then i could simply connect sql via the application and insert wrong data.</p>