Re: user permissions and super user - Mailing list pgsql-admin

From Andrew G. Hammond
Subject Re: user permissions and super user
Date
Msg-id E16BcoO-0006gS-00@xyzzy.lan.internal
Whole thread Raw
In response to user permissions and super user  ("Yuri A. Kabaenkov" <sec@artofit.com>)
List 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@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-----

pgsql-admin by date:

Previous
From: Manuel Trujillo
Date:
Subject: zlib & readline
Next
From: Jodi Kanter
Date:
Subject: found alternate solution