user permissions and super user

Поиск
Список
Период
Сортировка
От Yuri A. Kabaenkov
Тема user permissions and super user
Дата
Msg-id 11310207627.20011201123402@artofit.com
обсуждение исходный текст
Ответы Re: user permissions and super user
Список 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 по дате отправления:

Предыдущее
От: Dado Feigenblatt
Дата:
Сообщение: field order
Следующее
От: Ragnar Kjørstad
Дата:
Сообщение: Re: Clustering high-availability