Not long ago, Mike Field proclaimed...
> I'm getting a bit confused by the manual on this one, so excuse my
> ignorance.
>
> I want to set up a new ADMINISTRATOR for postgres databases. He already has
> his username in Linux. He needs to be able to:
>
> PREFERABLY:
> create db's
> destroy db's
> update db's
> backup db's
>
> AT LEAST:
> be able to update a db created by the postgres superuser (create tables,
> delete tables, etc...)
>
> How do I do this?
> If it's just the last criteria, is it just a question of doing
>
> CREATE USER username WITH PASSWORD password
>
> with the same userid and password for Linux, or what?
I just use the 'createuser' command. It asks you if you want the user to
be able to create/destory databases and other users.
Just run it at the Linux shell prompt:
$ createuser
-=Fozz
--
Doran L. Barton <[EMAIL PROTECTED]>
Iodynamics LLC -- "Internetworking the masses"
<URL:http://www.iodynamics.com/>
************
