Darren Clissold
Datafast, http://www.datafast.net.au
darren@datafast.net.au
-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Tuesday, March 30, 1999 5:07 PM
Subject: Re: [Emerald] Changing password via mailsite web console
>> Darren Clissold wrote:
>>
>> What is needed to make this work, we can login, set auto reply, etc
>> but cannot change the password,
>>
>> Attempting to change the password...Failed.
>>
>> How do I make it work.
>
>Mailsite needs access to the following proc. Its in Emerald 2.5:
>
>CREATE PROCEDURE ChangeMailUserPassword @login varchar(64), @domain
>varchar(64), @password varchar(16), @esid integer AS
>
>Update sa
>Set Password = @password
>From MasterAccounts ma, SubAccounts sa, Groups g, Domains d,
>AccountTypes at1
>Where ma.CustomerID = sa.CustomerID
> AND ma.GroupID = g.GroupID
> AND g.DomainID = d.DomainID
> AND at1.AccountType = sa.AccountType
> AND at1.ExternalSystemID = @esid
> AND (
> ( (sa.Login = @login or sa.Shell = @login) AND d.MailDomain = @domain)
> OR
> (sa.Email = @login + '@' + @domain)
> )
>GO
>
>
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>
>For more information about this list, including removal,
>please see http://www.iea-software.com/maillist.html
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html