i have a single sql database in sql server express.

i have a login MAINLOGIN, for this database.

i want insertion of data in this database through multiple users, U1,U2,U3, each having different userids & passwords.

These users would be created by MAINLOGIN , manually or via the winform application.

So while creating MAINLOGIN , i would give him permission to further create logins.

For this what should i do?

i cannot create MULTIPLE users, because for one database, only one user can be created under one login.

so should i create multiple logins, L1,L2,L3, then map, U1, U2, U3 to them.

Or, is there a better way to do this? like application roles etc.

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.