Where do we find the link between user and journal

Software Support
1

Hello,
In OJS2 we were able tot see the connection between an user and a journal in the table roles.
After upgrade to OJS3 it seems (in our case) that the table roles is not updated anymore.
So we are wondering, where is the connection between journal and user since OJS3?
We have a multi-journal OJS. The version is: OJS3.1.1.4, on PHP 7.3.18.

2

Hi @ugp2

The roles table is no longer part of the OJS3 database schema. Instead, the user_groups table contains the new “roles” for a context (journal), and users are assigned to these user groups via the user_user_groups table.

Cheers,
Jason

2 Likes
3

Thanks for your answer.

Kind regards