------=_NextPart_000_000A_01BE1228.3BFED1E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Dale,
I am prepare to implementing Rockliffe's MailSite, I wonder if I could =
get the store procedures which mentioned in there manual from you.
I foud the VerifyMailUser in your manual as follow:
CREATE PROCEDURE VerifyMailUser
@username varchar(32),
@domain varchar(32),
@esid integer
AS
SELECT Login,Shell,Email,d.MailDomain,Password,HomeDir
FROM MasterAccounts ma, SubAccounts sa, Groups g, Domains d, =
AccountTypes at
WHERE ma.CustomerID=3Dsa.CustomerID
AND ma.GroupID=3Dg.GroupID
AND g.DomainID=3Dd.DomainID
AND at.AccountType=3Dsa.AccountType
AND at.ExternalSystemID=3D@esid
AND (((Login=3D@username OR shell=3D@username)
AND d.Domain=3D@domain)
OR Email=3D@username + "@" + @domain)
There should be another store procedure ListMailUser I could not find.
++++++++++++++++++++++++++++++++++
Dan W Tang Domain Internet Access =20
IS Manager www.dmn.com.au
Tel: 61-8-9443 6000 Fax: 61-8-9443 6011
mailto:dan@dmn.com.au
++++++++++++++++++++++++++++++++++
=20
------=_NextPart_000_000A_01BE1228.3BFED1E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">