Re: [HACKERS] Solution to the pg_user passwd problem !?? (c) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Solution to the pg_user passwd problem !?? (c)
Date
Msg-id 199802201616.LAA05045@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Solution to the pg_user passwd problem !?? (c)  (Ronald Baljeu <rjb@xs4all.nl>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] How To free resources used by large object Relations?
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Permissions on copy