[Issue]: Auth Roles and Permissions

[RenaudBernier]

Branch Name

feature/7-roles

Task

There's already a roles column in the default users table in supabase auth, take a look

• Check documentation and learn how to setup custom roles using supabase auth.
• Create with a proxy/middleware from nextjs to protect the admin page only to role user admin.

Acceptance Criteria

• User should be able to have a role (admin, coach, user)
• Non admin user should be redirected to home page if trying to access admin page /dashboard/*.

Checklist

• I have checked for duplicate issues.
• I have assigned the issue to the correct project board.
• I have tagged the issue properly.

Code of Conduct

• I agree to follow this project's Code of Conduct

[achneerov]

Waiting on #4 as we need to know what tables each role needs