user permissions and super user - Mailing list pgsql-admin

From Yuri A. Kabaenkov
Subject user permissions and super user
Date
Msg-id 11310207627.20011201123402@artofit.com
Whole thread Raw
Responses Re: user permissions and super user
List pgsql-admin
Hello,


I have some databases and pg_hba.conf with this content:

------------
local   dialer password        dialer
host    dialer 127.0.0.1       255.255.255.255 password        dialer

local   helltop password        helltop
host    helltop 127.0.0.1       255.255.255.255 password        helltop

local   vote    password        vote

local   partnership     password        partnership
host    partnership     209.224.53.106  255.255.255.255 password        partnership
host    partnership     127.0.0.1       255.255.255.255 password        partnership

local   webstats        password        webstats
------------

How can i create user which users password authrization and can
access/modify/drop/create all these database.

Create languages on databases and so so so.

I've try to add line
local  all        password        all

And in 'all' file i add one user with password, but it doesn't work on
other datbases.







------------
With respect,
Yuri A. Kabaenkov
hellman@artofit.com


pgsql-admin by date:

Previous
From: Dado Feigenblatt
Date:
Subject: field order
Next
From: Ragnar Kjørstad
Date:
Subject: Re: Clustering high-availability