Create Different User Roles for ASP.Net Site

Greetings - I have an ASP.Net website that will have paid subscribers and free users. Free users will not have access to all features and pages. Subscribers will be able to not only access premium pages, but will also have the ability to enter unlimited transactions. For example: free users will have a limited ability to create new records on the SQL database, while paid users will not have the same limits. You should know MS SQL Server 2005 and 2008, as well as in-depth knowledge of SQL Authentication. You will have complete access to the SQL database (which is on GoDaddy, so you won't be able to use SSMS) as well as FTP access.