Thread: user permissions and super user

user permissions and super user

From
"Yuri A. Kabaenkov"
Date:
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


Re: user permissions and super user

From
"Andrew G. Hammond"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 2001 December 1 04:34 am, Yuri A. Kabaenkov wrote:

> 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.

  Sounds like you want a super-user.  Try creating a user and giving them the
ability to create new users and databases.

  The file you've been editing specifies which people are allowed to connect
to the database system and how they must authenticate themselves.  It does
not specify privilidges within the database system.  That stuff can be
controlled by GRANT and REVOKE.

- --
Andrew G. Hammond     mailto:drew@xyzzy.dhs.org   http://xyzzy.dhs.org/~drew/
56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F                  613-389-5481
5CD3 62B0 254B DEB1 86E0  8959 093E F70A B457 84B1
"To blow recursion you must first blow recur" -- me
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAjwOK7EACgkQCT73CrRXhLEiUACcDBz6Cgy5JJ0NGV9iYVtDlifL
PnMAniQbfDUidAvFcytOSFDSPApYEN+N
=9ouJ
-----END PGP SIGNATURE-----