Fetching user roles on client side

Use two tables as shown here,one for user details, a second for permissions.