Re: [ADMIN] users & groups

2000-06-19 Thread Rodney McDuff
[EMAIL PROTECTED] said: > I think we're pondering removing the secondary password file feature > sometime; The current system allows a particular user (in my case http) to connect to the database olny from the unix domain socket and no where else. What ever system is going to replace the secon

Re: [ADMIN] PGresult

2000-06-19 Thread Peter Eisentraut
Vladimir V. Zolotych writes: > Is it possible to have one PGresul inside another PGresult? > E.g. having some small PGresult while another (big) PGresult > still active? > > PGresult* res1 = PQexec (,,,) > for (...) { > // do some processing with res1. > PGresult* res2 = PQexec (

Re: [ADMIN] RE:

2000-06-19 Thread Mini-Me
it was part of a program generator written by someone in england i think, for pgsql. look for AppGEN. At 10:40 AM 6/19/00 -0500, Ross J. Reedstrom wrote: >On Mon, Jun 19, 2000 at 02:20:41PM +0100, Gary Stainburn wrote: > > Hi All, > > > > I'm trying to do the same thing here at work, and I've

Re: [ADMIN] RE:

2000-06-19 Thread Ross J. Reedstrom
On Mon, Jun 19, 2000 at 02:20:41PM +0100, Gary Stainburn wrote: > Hi All, > > I'm trying to do the same thing here at work, and I've looked at the mail list >archives. > > There's a reference to dbf2psql in a couple of messages, but can anyone point me to >a resource for it please. Hmm, all

Re: [ADMIN] users & groups

2000-06-19 Thread R D
--- Peter Eisentraut <[EMAIL PROTECTED]> wrote: > On Mon, 19 Jun 2000, R D wrote: > > > Hi,I need a secondary passwd files because I do > not > > know another way to manage user access to DBs. > > That's what I thought. > > > If there was a pg_shadow in every DB replacing > external passwd fil

RE: [ADMIN] RE:

2000-06-19 Thread Gary Stainburn
Hi All, I'm trying to do the same thing here at work, and I've looked at the mail list archives. There's a reference to dbf2psql in a couple of messages, but can anyone point me to a resource for it please. (Or if someone does what to write the How-To, I'd love a copy) Gary ---

Re: [ADMIN] users & groups

2000-06-19 Thread Peter Eisentraut
On Mon, 19 Jun 2000, R D wrote: > Hi,I need a secondary passwd files because I do not > know another way to manage user access to DBs. That's what I thought. > If there was a pg_shadow in every DB replacing external passwd file, Hmm, that would be in semi-violation of SQL, since users are supp

[ADMIN] RE: users & groups

2000-06-19 Thread Peter Eisentraut
On Mon, 19 Jun 2000, Nicolas Huillard wrote: > I think all that works in 7.0, not 6.5 ? Correct. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] users & groups

2000-06-19 Thread R D
--- Peter Eisentraut <[EMAIL PROTECTED]> wrote: > R D writes: > > > 1. If I'm using different password files for > each > > database can I grant or revoke privileges to this > > users without creating the same users in pg_user > > table? > > No, you always have to use CREATE USER. Btw., I > t

[ADMIN] RE:

2000-06-19 Thread Nicolas Huillard
Check the mail archive. There's plenty of answers... Maybe it's time to insert these answers in a FAQ or How-to, isn't it ? Nicolas Huillard -Message d'origine- De: Gagan [SMTP:[EMAIL PROTECTED]] Date: samedi 17 juin 2000 21:59 A: postgresql admin Objet: Dear friends, Can

[ADMIN] RE: users & groups

2000-06-19 Thread Nicolas Huillard
I think all that works in 7.0, not 6.5 ? (after RTFM a few months ago) Nicolas Huillard -Message d'origine- De: Peter Eisentraut [SMTP:[EMAIL PROTECTED]] Date: dimanche 18 juin 2000 16:17 A: R D Cc: [EMAIL PROTECTED] Objet: Re: users & groups R D writes: > 1. If I'm u