Re: Problem database access
От | Yann Collavoli |
---|---|
Тема | Re: Problem database access |
Дата | |
Msg-id | 49BA1509.4070801@cict.fr обсуждение исходный текст |
Ответ на | Re: Problem database access (Carol Walter <walterc@indiana.edu>) |
Список | pgsql-admin |
Hi,<br /><br /> Thank you very much, with this parameter it works like i want !!<br /><br /> Yann<br /><br /><br /> CarolWalter wrote: <blockquote cite="mid:E2CD6292-4B68-4D7B-BA10-CD99E9AABBAE@indiana.edu" type="cite"> If your users arethe database owners, you can set the "Only show owned databases?" option in the config.inc.php file for your PhpPgAdmin.<div><br /></div><div>Carol</div><div><br /><div><div>On Mar 12, 2009, at 7:31 AM, BRAHMA PRAKASH TIWARI wrote:</div><br/><blockquote type="cite"><div>Hi Yann</div><div>For below given purpose you need to create roles and assignthem separately to each database user or revoke the global permission from database and givepermission to concernuser only and also You need to change the password of global user.this is the best way by which You can achive yourrequirement.none can see others database<br /><br /></div><div>On Thu, Mar 12, 2009 at 4:52 PM, Yann Collavoli <span><<ahref="mailto:cyann@cict.fr" moz-do-not-send="true">cyann@cict.fr</a>></span> wrote:<br /><blockquote><div>Hi,<br /><br /> If i add this line "local all all trust", theuser "toto" can log in phpPgAdmin but he can see the others databases. Or, I want each user to access only its own databasethrough phpPgAdmin (for example, user “toto” access only at the database named “toto”). I think it's possible todo that but i don't understand how...<br /><br /> Regards<br /><br /> Yann <div><div><br /><br /> BRAHMA PRAKASH TIWARIwrote: <blockquote type="cite"><div>Hi you need to add following enty 100% it will resolve the problem</div><div> </div><div> </div><div>#"local" is for Unix domain socket connections only<br /> local all all trust<br /><br /><br /></div><div>On Thu, Mar 12, 2009 at 3:21 PM, Yann Collavoli<span><<a href="mailto:cyann@cict.fr" moz-do-not-send="true">cyann@cict.fr</a>></span> wrote:<br /><blockquote><div>Hello,,<br/><br /> Thank you for your help but it doesn't work with the line :<br /> host toto toto 0.0.0.0 0.0.0.0 md5<br /><br /> I've got the same error message :<br /> FATAL: no pg_hba.conf entry for host "[local]",user "toto", database "template1", SSL off<br /><br /> Yann<br /><br /> Tommy Cheng wrote: <blockquote type="cite">Trythis:<br /> host toto toto 0.0.0.0 0.0.0.0 md5<br /><br /><div>On Wed, Mar 11, 2009 at 9:02 PM, YannCollavoli <span><<a href="mailto:cyann@cict.fr" moz-do-not-send="true">cyann@cict.fr</a>></span> wrote:<br /><blockquote>Hello,<br/><br /> I am trying to install a postgresql 8.1 shared server. I want each user to access only itsown database through phpPgAdmin. For example, user “toto” access a database named “toto”, etc.<br /><br /> I used theselines to create the user and his database :<br /> bash-3.2$ createuser toto -P -D -A<br /> Enter password FOR new role:<br/> Enter it again:<br /> Shall the new role be allowed TO CREATE more new roles? (y/n) n<br /> CREATE ROLE<br />-bash-3.2$ createdb -O toto -E LATIN1 toto<br /> CREATE DATABASE<br /><br /> This is the contents of the file pg_hba.conf:<br /> # TYPE DATABASE USER CIDR-ADDRESS METHOD<br /> LOCAL sameuser ALL md5<br /> LOCAL ALL @admins md5<br /><br/> The “postgres” user (so the administrator of the database) can log in phpPgAdmin (without any problem). This usercan see all databases. When the user”toto” logs in phpPgAdmin, the connection failed and I get the following error messagein the postgres logs :<br /><br /> FATAL: no pg_hba.conf entry FOR host "[local]", user "toto", DATABASE "template1",SSL off<br /><br /> Do you have any idea about why it doesn’t work and how to correct it?<br /><br /> Thanksin advance for your help<br /><br /> Regards<br /><br /> Yann<br /><br /> -- <br /> Yann Collavoli<br /><br /> Tél: 05 61 36 60 20<br /><br /> Université Paul Sabatier<br /> CICT<br /> 118, route de Narbonne<br /> 31062 Toulouse Cedex<br/><br /><br /> -- <br /> Sent via pgsql-admin mailing list (<a href="mailto:pgsql-admin@postgresql.org" moz-do-not-send="true">pgsql-admin@postgresql.org</a>)<br/> To make changes to your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-admin" moz-do-not-send="true">http://www.postgresql.org/mailpref/pgsql-admin</a><br/></blockquote></div><br /></blockquote><br /><br/><pre>-- Yann Collavoli Tél : 05 61 36 60 20 Université Paul Sabatier CICT 118, route de Narbonne 31062 Toulouse Cedex</pre></div></blockquote></div><br /><br /><br /> -- <br /> Brahma Prakash Tiwari<br /> Database Administrator<br/> iBoss Tech Solution Noida<br /></blockquote><br /><br /><pre>-- Yann Collavoli Tél : 05 61 36 60 20 Université Paul Sabatier CICT 118, route de Narbonne 31062 Toulouse Cedex</pre></div></div></div></blockquote></div><br /><br /><br /> -- <br /> Brahma Prakash Tiwari<br /> DatabaseAdministrator<br /> iBoss Tech Solution Noida<br /></blockquote></div><br /></div></blockquote><br /><br /><pre class="moz-signature"cols="72">-- Yann Collavoli Tél : 05 61 36 60 20 Université Paul Sabatier CICT 118, route de Narbonne 31062 Toulouse Cedex</pre>
В списке pgsql-admin по дате отправления: