When the user create a new user account in MM.NET, does it automatically create a SQL user account?

Can you tell me how I can use your security scheme for a shrink wrap software situation? The backend will be MSDE and since MSDE does not have an user interface, the user will not be able to create user account on MSDE.