Re: GRANT all to a super user

On 2009-05-27, Gauthier, Dave <dave.gauthier@intel.com> wrote:
> --_000_482E80323A35A54498B8B70FF2B87980040AEFF544azsmsx504amrc_
> Content-Type: text/plain; charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> What is the (is there a) grant command that I can use to create a super use=
> r without having to specify all the DB objects?

SUPERUSER cant be GRANTed, it's done with ALTER USER instead..

ALTER USER fred WITH SUPERUSER.

as a superuser fred can now do anything that other superusers (eg, "postgres")
can do. ( ie: create users, etc..) if you don't want that you may instead want
to grant fred the role of the database ownwer,

assuming the database owner is "dave"

GRANT dave TO fred;

use WITH ADMIN OPTION at the end if you want to let fred invite bill
to the party too.