Showing multiple roles assigned to a user in Laravel using Spatie Permissions

Question

does anyone know how to show multiple roles that are under a user? I have setup my permissions so a user can be under multiple roles, which is set easily enough using the following

$user->assignRole(['Root', 'IT', 'HR']); // assigning roles

I am however having trouble showing all roles a user relongs to in the same way? Has anyone done this and knows how to? I simply want to show on a page which role a user belongs to.

score 3 · Accepted Answer · answered Apr 20 '21 at 06:18

3

Refer to this link

https://spatie.be/docs/laravel-permission/v4/basic-usage/basic-usage

Get the names of the user's roles

$roles = $user->getRoleNames();

Returns a collection

answered Apr 20 '21 at 06:18

Vicky Gill

714
1
7
21

score 2 · Answer 2 · answered Apr 20 '21 at 06:13

2

if there are two tables (roles and user_roles) than you can check through inner join ('inner join' to check role must exist in 'roles' table that is assigned to a user) by passing user_id (user_id to get specific roles assigned by a user).

answered Apr 20 '21 at 06:13

Atif Mahmood

390
1
11

2

$get = DB::table('users_roles') ->join('roles', 'roles.id', '=', 'users_roles.role_id') ->select('roles.id', 'roles.name', 'users_roles.user_id') ->where('users_roles', $req->user_id) ->orderBy('roles.id', 'ASC') ->get(); – Atif Mahmood Apr 20 '21 at 06:16

score 1 · Answer 3 · answered Apr 20 '21 at 00:19

1

You can get a collection of roles assigned to the user via $user->roles

answered Apr 20 '21 at 00:19

ibra

390
3
13

Showing multiple roles assigned to a user in Laravel using Spatie Permissions

3 Answers3