Role provider using for the authenticated user access to the pages. like example.com/users can not be reached by ananoymous access then you will need to put a web.config under users folder and that file will include these lines:

<?xml version="1.0" encoding="utf-8"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<system.web>
<authorization>
<allow roles="User" />
<deny users="*" />
</authorization>
</system.web>
</configuration>

with this way we are saying to asp.net framework no one except user roled users can reach that folder.

for this you gonna need sqlite role provider class. and this dll and this db.