It sounds like the poster is trying to relate the login user table (in one db) to some other table (in another db) containing data and/or relationships pertinent to that user. He sounds frustrated because the StarterSite security tables contain very little
info on the user other than the email (which suffices as the userid/username). He is looking to either:
(1) Extend the User Profile table to include additional (and possibly redundant) attributes of the user or
(2) Find some way to implement the Security functionality in his own tables/database or
(3) Find some way to establish a relationship (across two databases) between the user's row in the UserProfile table in the security db and the user's row in his yet-unspecified application database.
None of these seems to be the best way to do this. The target audience of WebMatix is very likely to not have the knowldge and'or fortitude to diddle with the security database.
Is it possible to implement the StarterSite database's security tables in the site's application database and then create an enforceable/maintainable relationship between the two tables that would now be in the same database?
If some similar solution to this exists, the guru who can write a comprehensible tutorial to illustrate the solution would be doing a great service to the WebMatrix user community!
rrrsr7205
Participant
1304 Points
313 Posts
Re: User ID and Password
Apr 06, 2011 09:33 PM|LINK
It sounds like the poster is trying to relate the login user table (in one db) to some other table (in another db) containing data and/or relationships pertinent to that user. He sounds frustrated because the StarterSite security tables contain very little info on the user other than the email (which suffices as the userid/username). He is looking to either:
(1) Extend the User Profile table to include additional (and possibly redundant) attributes of the user or
(2) Find some way to implement the Security functionality in his own tables/database or
(3) Find some way to establish a relationship (across two databases) between the user's row in the UserProfile table in the security db and the user's row in his yet-unspecified application database.
None of these seems to be the best way to do this. The target audience of WebMatix is very likely to not have the knowldge and'or fortitude to diddle with the security database.
Is it possible to implement the StarterSite database's security tables in the site's application database and then create an enforceable/maintainable relationship between the two tables that would now be in the same database?
If some similar solution to this exists, the guru who can write a comprehensible tutorial to illustrate the solution would be doing a great service to the WebMatrix user community!