Get Users for Role using different sqlserver databases

[AlessioGiacobbe]

Hi!
i'm trying to setup laravel-permissions using two different sql server databases, my user model connects to 'sqlsrv', all the Role/Permission/pivots tables are on 'sqlsrv2', i configured my Role model like this :

use Spatie\Permission\Models\Role as SpatieRole;

class Role extends SpatieRole
{
    protected $connection= 'sqlsrv2';
}

Configuring the role and permission models like this works fine when it comes to insert and associate them, but it doesn't work when i try to retrieve all the users for a specific role, like this : $users = $role->users()->get();
Because he tries to locate the pivot table on the first connection instead of the second one (where the table is located).

Am i missing something?

[AlessioGiacobbe]

If somebody else is stuck in this situation, I think I have found a good solution, setting the full database path in the permissions configuration seems to work (at least with sql server).
Eg. 'model_has_roles' => 'Database.dbo.model_has_role'