I’m going to make a rather big system using asp.net and I’ve been looking at the login controls. When I use login controls and creates users, roles etc. a standard “member database” is being created automatically.
Now, the system is of course going to contain alot more information, and other database tables will need username/userID or something like that (the primary key in the automatically created database).
Where should I create these tables then? In the same database as the (15 or so) automatically generated user tables or in a separate database (in that case, can I run sql queries that joins tables from both databases together?)