Is there a good way to make the database server send e-mail?
От | Berend Tober |
---|---|
Тема | Is there a good way to make the database server send e-mail? |
Дата | |
Msg-id | 65066.216.238.112.88.1043083071.squirrel@$HOSTNAME обсуждение исходный текст |
Ответы |
Re: Is there a good way to make the database server send e-mail?
Re: Is there a good way to make the database server send e-mail? |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: