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 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
__    _  _      _  _
|_|_||_||_||\/||_|| \
_|| || || \|  || ||_/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to