From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
---|---|
To: | "Berend Tober" <btober(at)seaworthysys(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Is there a good way to make the database server send e-mail? |
Date: | 2003-01-20 17:24:30 |
Message-ID: | 20030120172430.C2E2C103E6@polaris.pinpointresearch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Perhaps this would work: http://sourceforge.net/projects/pgmail/
(I've never used it, just happened across it this weekend).
Cheers,
Steve
On Monday 20 January 2003 9:17 am, Berend Tober wrote:
> Is there a good way to make the database server send e-mail?
>
> I've been ask to work on a (Windows, client-server) application and
> implement a feature whereby duely authenticated and connected users can
> reset the password of other users without having to have DBA privileges.
> I've got that part working by using a stored procedure with the SECURITY
> DEFINER attribute (and the function is created by a DBA user) that calls
> ALTER USER...
>
> My next step is to have the database mail the new password to the reset
> user (the system uses e-mail addresses as usernames, so the database knows
> how to contact the user), along with the username of the person doing the
> resetting. I need help with suggestions on learning how to make the
> database server initiate an e-mail message.
>
>
> Regards,
> Berend Tober
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-01-20 17:28:44 | Re: reference to system table |
Previous Message | Berend Tober | 2003-01-20 17:17:51 | Is there a good way to make the database server send e-mail? |