Extract user role to dedicated view.
Add more complete views for bans.
Restructure ban query.
Change login to account for banned users.