user permissions
select u.name,r.role from users u
inner join roles r
on u.role_id=r.id
where r.role='princ' and u.username='bleh' and u.password='bleh'