AiiDA shared infrastructure (database+dos, broker, daemon) between multiple unix users (multi-user, multi user)

[agoscinski]

AiiDA does not test well the use case when multiple users share a database. This is a meta issue to track anything related to this

• Filter active processes for the default user when running verdi process repair #6879
• The storage structure, suggested for a different feature, would be more suitable in this case CLI: Add the verdi init command #6315 (comment)
• Do we need orm.User in the first place? Can't this be all be solved by just having separate profiles that share database, broker and daemon. Requires that daemon can be started for all profiles once but this is definitely feasible, it is only an user api question.
• The ZeroMQ broker is also per-profile for the moment but this needs to be changed to solve Make ZMQ a completely relpacement for RMQ #7549