Re: change user password

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: Hugo <htakada(at)tresleones(dot)com(dot)py>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: change user password
Date: 2005-02-21 11:30:46
Message-ID: 200502210830.47958.martin@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

El Jue 17 Feb 2005 14:27, Hugo escribió:
> 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?

Why not use ALTER USER?

--
08:30:14 up 161 days, 22:25, 3 users, load average: 1.03, 0.68, 0.65
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matt Kynaston 2005-02-21 11:38:45 Re: Porting MySQL PHP to Postgres
Previous Message Surabhi Ahuja 2005-02-21 10:44:01 error while loading shared libraries: