Use This Package for Pivot Table

[annis-souames]

I have many-to-many relationship (user-team), so a user can join multiple teams and a team can have multiple users, at first I was adding permissions only in team model, but I need to add it in team-user pivot table through this package, so a user can have different permissions for each team he has joined ? Any Ideas how can I achieve this.

[bhushan]

facing same kind of issue ..

[brandon-9]

Crude, and early, but I have the same situation. I created a "teamAccess" model/table to store the roles.
id | team_id | user_id

I check the active team (team ID 1) stored on the User table, then going through the team, I find the teamAccess where team_id = user_active_team_id

User Model:
public function teamAccess()
{
return $this->hasMany(TeamAccess::class);
}

Then I have a Policy with a condition:
$user->teamAccess()->where('team_id', $user->team_id)->first()->hasPermissionTo('create')

Might get you somewhere...

[sys-auditing]

Hi @annis-souames, did you figure out the solution ?

[Hesesses]

I'm working on something similar deciding between this package or creating something custom...

Could this be handled with subparts?
https://spatie.be/docs/laravel-permission/v4/basic-usage/wildcard-permissions#subparts

$user->givePermissionTo('posts.*.1,4,6');

You would specify the wanted team_ids

[kaaaaaaaaaaai]

@annis-souames @bhushan @sys-auditing @Hesesses @brandon-9
I'm working on something similar.
Did you find a solution?

[erikn69]

discussions 1782
That's my solution, it's not the best way to do it, but it's been working for me for years.

[AlexanderFalkenberg]

@erikn69 can you tell me what usua_id, empr_id in your screenshot mean and what they are refencering to. I'm a little confused.

[erikn69]

Really old answer, i make this feature native
#1804
teams-permissions