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

>
> > >
> > > > ------- 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(at)candle(dot)pha(dot)pa(dot)us