As part of the trigger that populates the Imail fields in our DB, it adds the right
value depending on parameters we set. i.e: All employes under the IT department
automatically have MB 50 (50000000) as the allowed mailbox size, but the student
employees only get 10. - We use the trigger to fill out the fields dependent on the
content of other fields. After that, Imail access it just like any other database.
The data is accessed as the ODBC user configured in Imail, and yes, there is full
functionality. (change PW, etc)
---------- Original Message ----------------------------------
From: "A Bivol Oleg" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 22 Mar 2000 09:54:48 +0100
>Salavatore,
>Are you able today with your system to manage such attrubutes=20
>for user as: user can change password, mail box size, domain =
>administrator,
>account acces disabled etc...
>Or you are just managing user and password ?
>Thanks,
>Oleg Bivol=20
>-----Message d'origine-----
>De : Salvatore Giacinto [mailto:[EMAIL PROTECTED]]
>Envoy=E9 : Wednesday, March 22, 2000 12:08 AM
>=C0 : [EMAIL PROTECTED]
>Objet : Re: [IMail Forum] Imai full administration with SQL7.0 ?
>
>
>We are managing a list of users that already exist in an external SQL =
>7.0
>database. The users are part of a HR/Payroll system that runs on SQL. =
>We
>created a view to extract the user information that IMail wants and
>programmed some triggers to automatically populate the IMail fields =
>when a
>user changes. The result is a self managed system. When an
>addition/deletion occurs in the payroll system (a new employee comes), =
>the
>IMail account exists as part of that employee record in the payroll db. =
> IT
>just assigns a password and that's it. I cannot perceive doing this =
>any
>other way. It's the only real benefit for being able to use an =
>external
>database. That's what it's for, right?
>
>
>
>
>Please visit http://www.ipswitch.com/support/mailing-lists.html
>to be removed from this list.
>
--
---------------------------
Salvatore Giacinto
[EMAIL PROTECTED]
http://www.mailnet.de
---------------------------
--
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
