Greetings, Sharmad!
At 18.07.2001, 07:41, you wrote:
SN> Thanks Alexey,
SN> I have set the passwd for the root user,but now how do i set
SN> the passwd for other users.
CREATE USER another_user WITH PASSWORD 'password';
or
ALTER USER another_user WITH PASSWORD 'password';
SN> Another Q ,Can I have a passwd for each table created
No, but you can RTFM about 'GRANT' and 'REVOKE' commands.
Besides, your questions have nothing to do with PHP at all. There
are quite good PostgreSQL mailing lists, info here:
http://www.ca.postgresql.org/users-lounge/index.html
SN> 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
>>
--
Yours, Alexey V. Borzov, Webmaster of RDW.ru
--
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]
