Re: [HACKERS] Solution to the pg_user passwd problem !?? (c)

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Solution to the pg_user passwd problem !?? (c)
Дата
Msg-id 199802201616.LAA05045@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Solution to the pg_user passwd problem !?? (c)  (Ronald Baljeu <rjb@xs4all.nl>)
Список pgsql-hackers
>
> > >
> > > > ------- OTHER WISE ---- CAN WE STEAL IDEAS FROM OTHERS? --------
> > > >
> > > > I'm also running MySQL (trying to switch to PG, but waiting for ODBC
> > > > to catch up), I like the mysql feature of inserting passords by:
> > > >
> > > >     insert into user (host,user,password)
> > > >     values ("domain.com","dlorenso",password('psswrd');
> > >
> > > Hmmm... When I read this, another (related) idea pops into my head.
> > > It's probably nothing, but:
> > >
> > > what about defining a new type 'passwd', with
> > > an input (or output) routine which does the crypting?
> >
> > If they do a binary cursor, does the output function get called?
>
> Oops, I haven't thought about that. I guess it doesn't :(
> Ok, what about an input routine that does the crypting?
>
> One down, one to go...
>
> Cheers,
> Ronald
>

Then, the backend can't find the original password to test the random
salt on.
--
Bruce Momjian
maillist@candle.pha.pa.us

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] How To free resources used by large object Relations?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Permissions on copy