Re: FW: [ppa-dev] Severe bug in debian - phppgadmin opens
От | Bruce Momjian |
---|---|
Тема | Re: FW: [ppa-dev] Severe bug in debian - phppgadmin opens |
Дата | |
Msg-id | 200111291637.fATGb5l04008@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: FW: [ppa-dev] Severe bug in debian - phppgadmin opens up ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>) |
Список | pgsql-hackers |
> > > Try "ps axewww" ? Doesn't work on your platform ? > > > Works on AIX, Linux?, ... > > > > Linux Debian Unstable (updated 1 week ago). > > > > For a non-root user, only her processes' environment appears. > > (and /proc/*/environ permissions are 400, the user being the > > process owner) > > > > For root, all processes' environment is shown. > > > > Antonio > > I've tried it on FreeBSD and it seems an unprivlileged user can only see his > or her own environmental variables, it doesn't show variables for any other > user. Yes, I see that now. Seems maybe my OS is the only one that isn't fixed yet. :-( Anyway, I based my dislike of passwords in the environment on prior practice of other programs. I knew one of the reasons it isn't used is because of 'ps', but there is also the issue of the passwords passed to subprocesses, across 'su' calls, and into 'core' files. It just seems like a bad practice. Passwords stored in a file, though not ideal, seems more secure, are used by cvs and a few other programs, and allow us to define a format that can be used to store different user/host/password combinations in the same file, if we wish. Of course, given that most OS's don't have the 'ps' environment problem, maybe we have to keep PGPASSWORD around. It is up to the group. Do people want me to change my wording of the option in the SGML sources? <envar>PGPASSWORD</envar> sets the password used if the backend demands password authentication. This is not recommendedbecause the password can be read by others using a <command>ps</command> environment flag on some platforms. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
В списке pgsql-hackers по дате отправления: