Wheres exactly Asp .Net MVC access rule information is stored in a sql server DB?

Question

Where does sql asp net mvc stores role access in a sql database if it actually does?

I found information regarding user membership and roles but not about access rules.

Answer 1

You should do some research on the SqlMembershipProvider. There's a good tutorial on the schema it creates on the ASP.NET website.

In short, if you use the aspnet_regsql.exe tool, the appropriate tables will be created in your database, prefixed with 'aspnet_'.

Edit:

As for access rules, those are not stored in the database. In MVC, authorization is generally accomplished in code using the Authorize attribute, either at the action level or sometimes for an entire controller.

public class HomeController : Controller
 {
     public ActionResult Index()
     {
         return View();
     }

     public ActionResult About()
     {
         return View();
     }

     [Authorize]
     public ActionResult AuthenticatedUsers()
     {
         return View();
     }

     [Authorize(Roles = "Admin, Super User")]
     public ActionResult AdministratorsOnly()
     {
         return View();
     }

     [Authorize(Users = "Betty, Johnny")]
     public ActionResult SpecificUserOnly()
     {
         return View();
     }
 }