Hi,
I would like to allow users to use any known "alias" of another user to grant permissions to their mailboxes.
Here's the scenario:
A user, with an internal name "example@12345" and an alias "test@example.org". The domain "12345" is only used internally to separate the customers into different directories, therefore "anotheruser" only knows the address "test@example.org" grants folder permissions to "test@example.org". This results in the following:
+-------------------------+--------------------------------------------+-------+ | from_user | to_user | dummy | +-------------------------+--------------------------------------------+-------+ | anotheruser@12345 | test@example.org | 1 | +-------------------------+--------------------------------------------+-------+
But since the actual username is "example@12345" the proper directory can't be found.
I would like to achieve the following outcome, with the same user inputs:
+-------------------------+--------------------------------------------+-------+ | from_user | to_user | dummy | +-------------------------+--------------------------------------------+-------+ | anotheruser@12345 | example@12345 | 1 | +-------------------------+--------------------------------------------+-------+
Is it possible to populate the to_user column with a more dynamic sql lookup instead of the dict lookup?
Thanks in advance, Matthias