mysql - ASP MySQLRoleProvider tie roles to users -
I would like to use mysql role provider for aspnet. I have a custom table setup for user userTableName = "user" The problem now using the feature is that when I assign roles to users, MYSQLRolesprovider creates an entry in a table "my_aspnet_usersinroles" and "my_aspnet_users" I want to specify that the roles used to specify To be done Alika "Users should be" table. How do I do that? Do I Need to Write a Custom Role Provider? Is there a setting that I can emphasize to build that union? Or am I just using this whole system wrong? Thank you
You need separate tables for users and their roles. Generally, it's three in total, one for users, one for roles and one or more roles to tie the user. Users' tablets allow one to have multiple relationships so that your user can have more than one role. In addition, good database design will give this instruction as well as the user table should include only related artifacts directly related to the user.
Comments
Post a Comment