Upon his requirement, you also need to grant this administrator as a superuser of
postgres
when you run shell command createuser.
--Banghe
"Doran L. Barton" wrote:
> 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/>
>
> ************
************
