How to create a Login scheme to allow a user to view individual information

[Wheater]

Beginning C# programmer here. I have had lots of problems finding online a tutorial or help-me thread where someone explains how to create the specific type of user profile database I need.

I need to use SQL and C#.NET to create a profile/role for each specific user on my website. Every single user will have private information that only he/she should be able to view.

All tutorials I have found so far only create roles such as admin, member and guest. Does anyone know how to do this? If I could use the built in login tools that .Net offers, that would be great.

Thanks in advance!

[hericles]

You can simply save the user with each role they have. The role would be another column in the log in table. Functions that have restricted access can check the assigned role. I think you were looking at how to give a user access to a database table which isn't what you need.
You mention you need to "create a profile/role for each specific user on my website". That makes it sound like every user will have a different role. If each user's role will be different why bother with roles anyway? Their user login credentials will set them apart from everyone else.

[MikeyIsMe]

Wheater,

Do you wish to use your own database for this or the built in ASP.Net database? As this can very easily be done using the built in one however I've had issues in the past trying to then link the ASP.Net DB to a custom one for the other details.

I have also done the login using my own DB and also managed to restrict access to pages using code on the master page but this was not so easy, all depends on what other functionality your database has.