password() function?

is there a password() function in postgres? something similar to
mySQL?

I'm not sure why, when you post to a postgresql news group, you would
assume knowlege of how some other product works. That's kind of like
using Microsoft products as your frame of reference on an open-source
news group. Bad form. It would be more useful if you pointed out more
specifically the functionality you are inquiring about.

That flame extinquished, if what you are looking for is a way to change
passwords, you can use ALTER USER inside a stored procedure.

What I do is create the stored procedure as owned by a superuser, and
then grant select privileges on the procedure to an admin group so that
my customers have the ability to change passwords without having to
actually have dba privileges to the database. Same thing for CREATE USER,
DROP USER, ALTER GROUP, etc.

You're probably looking for something like the crypt() or the
crypt_md5() function supplied in de contrib/pgcrypto module.

Regards,

Arjen

On Thu, 2003-02-06 at 10:59, Berend Tober wrote:

is there a password() function in postgres? something similar to
mySQL?

I'm not sure why, when you post to a postgresql news group, you would
assume knowlege of how some other product works. That's kind of like
using Microsoft products as your frame of reference on an open-source
news group. Bad form. It would be more useful if you pointed out more
specifically the functionality you are inquiring about.

I think it's worse etiquette to flame people when they are just trying
to get help. If his question doesn't make sense to you, ask for
clarification, don't criticize him for asking the question in a way that
you don't understand. And besides, given that everyone knows people are
switching from mysql to postgresql by the thousands, he probably just
took for granted that some of the people here would know what he was
talking about without having to give a full breakdown.

Peter, do some searching on pgcrypto, you'll find what your looking for.

Robert Treat

On Thu, Feb 06, 2003 at 10:59:58AM -0500, Berend Tober wrote:

That flame extinquished, if what you are looking for is a way to change
passwords, you can use ALTER USER inside a stored procedure.

Or it might be a way of storing passwords, in which case reading the
README in contrib/pgcrypto might help.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

Besides that, last time I checked MySQL was not owned by Microsoft ;)

Arjen

On Thu, Feb 06, 2003 at 10:59:58AM -0500, Berend Tober wrote:

That flame extinquished, if what you are looking for is a way to
change passwords, you can use ALTER USER inside a stored procedure.

Or it might be a way of storing passwords, in which case reading the
README in contrib/pgcrypto might help.

Yes, indeed it might. And that reference might help him. Would have been
nice, as I attempted to teach him, though, if the question had been
framed in a way appropriate for this forum. I'm not going to waste my
time reading the mySQL documentation to figure out his question about
PostgreSQL, however. No apologies here.

i didn't mean to get people upset about this whole. i appreciate all the
help that i received for everyone.

i'll try to ask better questions next time.

Peter Choe

At 01:27 PM 2/6/2003, Berend Tober wrote: