Re: password() function?
От | Berend Tober |
---|---|
Тема | Re: password() function? |
Дата | |
Msg-id | 34741.12.111.55.140.1044547198.squirrel@$HOSTNAME обсуждение исходный текст |
Ответ на | password() function? (Peter Choe <choepete@mindspring.com>) |
Ответы |
Re: password() function?
Re: password() function? |
Список | pgsql-general |
> 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.
В списке pgsql-general по дате отправления: