simple membership tables in asp.net mvc 4

See more:

MVC4

ASP.NET4

We are using Internet Application in ASP.Net MVC 4 project. Since Simplemembership is out of the box feature hence membership creates the following table on our database :

webpages_Membership
webpages_Roles
webpages_UsersInRoles

But our database team, is not ready to have table names prefix with "webpages". They are ok to create the following table:

SC_Membership
SC_Roles
SC_UsersInRoles

where "SC" prefix is specific to our project.


Now is it ok if we create a Database view as webpages_Membership on top of SC_Membership table and so our membership provider should connect to view for authenticating the user. Is it possible. Any thought on this would be highly appreciated.

-Sanjiv