hi, is it possible to change the user's password from a stored procedure or a funcion? I mean , is there a system function/stored procedure that can do it? like the dbo.sp_password found in Adaptive server anywhare? thanks in advance Hugo ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org