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