[Feature Request]: Permissions based on Category/Department

[Saueee]

Is your feature request related to a problem? Please describe.

Our Company consists of three departments which do mostly their own asset management but with some overlap.
Now we want to create groups of users so each group can only read/create/edit.. the department specific assets.
Some users should be in multiple departments and can see assets from more than one department.

This very common use case seems to be impossible to create. Do we miss something?
We can either deny a user access to assets at all or show him ALL assets of the whole company. Is this correct?

Describe the solution you'd like

Posiblity 1:
Be able to set permissions based on (at least) department and category.
Make department an optional default multiple choice field for assets.
Make multiple choice drop down list in the group edit menu, where you can set access to specific categories and/or department specific assets.

Posibility 2:
Make it possible to add another "high class" model (like assets/license/components) for example "Assets-Lab".
It will look exactly like Assets in the list on the left. Basically just creating a new separate list of assets.
This can be given permission with the curently available permission model -> create group and allow Assets-Lab but deny Assets.

Describe alternatives you've considered

Multi Tenant mode is not usable for this scenario. People cannot be in multiple companies.
Even Admins cannot see users from the different company to assign them assets.
People that need access to multiple "companies" would need super admin which is not how it should be like.

Additional context

No response

[welcome]

👋 Thanks for opening your first issue here! If you're reporting a 🐞 bug, please make sure you include steps to reproduce it. We get a lot of issues on this repo, so please be patient and we will get back to you as soon as we can.

[Leitwolf90]

We have nearly a similar request.
I would rather go with Option 1: granting a group access to a specific asset category