Re: [ADMIN] Problem database access

2009-03-13 Thread Yann Collavoli
Hi, Thank you very much, with this parameter it works like i want !! Yann Carol Walter wrote: If your users are the database owners, you can set the "Only show owned databases?" option in the config.inc.php file for your PhpPgAdmin. Carol On Mar 12, 2009, at 7:31 AM, BRA

Re: [ADMIN] Problem database access

2009-03-12 Thread Carol Walter
If your users are the database owners, you can set the "Only show owned databases?" option in the config.inc.php file for your PhpPgAdmin. Carol On Mar 12, 2009, at 7:31 AM, BRAHMA PRAKASH TIWARI wrote: Hi Yann For below given purpose you need to create roles and assign them separately to

Re: [ADMIN] Problem database access

2009-03-12 Thread BRAHMA PRAKASH TIWARI
Hi Yann For below given purpose you need to create roles and assign them separately to each database user or revoke the global permission from database and givepermission to concern user only and also You need to change the password of global user.this is the best way by which You can achive you

Re: [ADMIN] Problem database access

2009-03-12 Thread Ashish Karalkar
Yann Collavoli wrote: Hi, If i add this line "local all all trust", the user "toto" can log in phpPgAdmin but he can see the others databases. Or, I want each user to access only its own database through phpPgAdmin (for example, user “toto” access only at the database named “toto”). I thi

Re: [ADMIN] Problem database access

2009-03-12 Thread Yann Collavoli
Hi, If i add this line  "local   all all   trust", the user "toto" can log in phpPgAdmin but he can see the others databases. Or, I want each user to access only its own database through phpPgAdmin (for example, user “toto” access only at the database named

Re: [ADMIN] Problem database access

2009-03-12 Thread BRAHMA PRAKASH TIWARI
Hi you need to add following enty 100% it will resolve the problem # "local" is for Unix domain socket connections only local all all trust On Thu, Mar 12, 2009 at 3:21 PM, Yann Collavoli wrote: > Hello,, > > Thank you for your help but it doesn't work

Re: [ADMIN] Problem database access

2009-03-12 Thread Yann Collavoli
Hello,, Thank you for your help but it doesn't work with the line : host    toto     toto 0.0.0.0 0.0.0.0 md5 I've got the same error message : FATAL:  no pg_hba.conf entry for host "[local]", user "toto", database "template1", SSL off Yann Tommy Cheng wrote: Try this: host    toto    

[ADMIN] Problem database access

2009-03-11 Thread Yann Collavoli
Hello, I am trying to install a postgresql 8.1 shared server. I want each user to access only its own database through phpPgAdmin. For example, user “toto” access a database named “toto”, etc. I used these lines to create the user and his database : bash-3.2$ createuser toto -P -D -A Enter pa