I'm sure this is a common problem but I'm not able to find any good solution nor at least something that leads me to the right track. Additionally, I have no experience with LDAP so far, maybe this is why I cannot find anything related.
I've running a mail server with Postfix, Dovecot, MySQL, rspamd and Redis on AlmaLinux 9 so far and this system works great. Now I want to switch from SQL-based authentication to LDAP. There is a lot of information out there about using LDAP.
But I cannot find anything about having a mail address (e.g. box@example.com) which can be accessed by multiple users (e.g. foo and bar). Foo and bar should have it's on addresses as well (foo@example.com and bar@example.com). Now I want that foo and bar can authenticate for box as well while reading, writing, deleting etc. mails as they can in their own mail boxes.
The goal is to easily give access to box@example.com by adding an existing user to a kind of whitelist without having a separate password for box@example.com. Only enlisted users can login into box. Additionally, I thought about using Kerberos for a one-time-authentication but that's too heavy for me at the moment.
The only thing that I found is to redirect any mails of box@example.com to Foo and Bar, but that's more like a mailing list, which I do not want to implement.
Therefore, I appreciate any help about how to solve that.