Re: Problem database access

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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, BRAHMA PRAKASH TIWARI wrote:

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 your requirement.none can see others database

On Thu, Mar 12, 2009 at 4:52 PM, Yann Collavoli <cyann@xxxxxxx> 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 think it's possible to do that but i don't understand how...

Regards

Yann


BRAHMA PRAKASH TIWARI wrote:
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 <cyann@xxxxxxx> wrote:
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     toto 0.0.0.0 0.0.0.0 md5

On Wed, Mar 11, 2009 at 9:02 PM, Yann Collavoli <cyann@xxxxxxx> wrote:
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 password FOR new role:
Enter it again:
Shall the new role be allowed TO CREATE more new roles? (y/n) n
CREATE ROLE
-bash-3.2$ createdb -O toto -E LATIN1 toto
CREATE DATABASE

This is the contents of the file pg_hba.conf :
# TYPE DATABASE USER CIDR-ADDRESS METHOD
LOCAL sameuser ALL md5
LOCAL ALL @admins md5

The “postgres” user (so the administrator of the database) can log in phpPgAdmin (without any problem). This user can see all databases. When the user”toto” logs in phpPgAdmin, the connection failed and I get the following error message in the postgres logs :

FATAL: no pg_hba.conf entry FOR host "[local]", user "toto", DATABASE "template1", SSL off

Do you have any idea about why it doesn’t work and how to correct it?

Thanks in advance for your help

Regards

Yann

--
Yann Collavoli

Tél : 05 61 36 60 20

Université Paul Sabatier
CICT
118, route de Narbonne
31062 Toulouse Cedex


--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



-- 
Yann Collavoli

Tél : 05 61 36 60 20

Université Paul Sabatier
CICT
118, route de Narbonne
31062 Toulouse Cedex



--
Brahma Prakash Tiwari
Database Administrator
iBoss Tech Solution Noida


-- 
Yann Collavoli

Tél : 05 61 36 60 20

Université Paul Sabatier
CICT
118, route de Narbonne
31062 Toulouse Cedex



--
Brahma Prakash Tiwari
Database Administrator
iBoss Tech Solution Noida



-- 
Yann Collavoli

Tél : 05 61 36 60 20

Université Paul Sabatier
CICT
118, route de Narbonne
31062 Toulouse Cedex

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux