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