Re: user permissions and super user

From: "Andrew G(dot) Hammond" <drew(at)xyzzy(dot)dhs(dot)org>
To: sec <sec(at)artofit(dot)com>, Pgsql-Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: user permissions and super user
Date: 2001-12-05 14:14:04
Message-ID: E16BcoO-0006gS-00@xyzzy.lan.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

-----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(at)xyzzy(dot)dhs(dot)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-----

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jodi Kanter 2001-12-05 14:53:44 found alternate solution
Previous Message Manuel Trujillo 2001-12-05 12:33:02 zlib & readline