On 2009-05-27, Gauthier, Dave <dave.gauthier@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
