Re: password

Thanks Alexey, I have set the passwd for the root user,but now how do i set the passwd for other users. Another Q ,Can I have a passwd for each table created -Thanks Sharmad On Tue, Jul 17, 2001 at 11:10:31AM +0400, Alexey Borzov wrote: > Greetings, Sharmad! > > At 17.07.2001, 08:27, you wrote: > > SN> Hi, > SN> Can anyone tell me how to protect my database or else how can i set my password > SN> in postgres for every database. > Can you be more specific? > If your problem is that anyone can connect to any DB on local box > (which is the default setup), then you need to edit pg_hba.conf > This file resides in the root of your DB data dir. You should seek > the lines which read like these: > --------------------- > local all trust > host all 127.0.0.1 255.255.255.255 trust > --------------------- > and change 'trust' to 'password'. > Well, I hope I understood your question correctly... > > -- > Yours, Alexey V. Borzov, Webmaster of RDW.ru > -- Donot rely on the Operating System which don't have any sources for. -Seen somewhere on the Net __ _ _ _ _ |_|_||_||_||\/||_|| \ _|| || || \| || ||_/