Re: createuser problem

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: manu(dot)mp(at)maildrop(dot)m2comsys(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: createuser problem
Date: 2003-12-11 09:48:40
Message-ID: 1071136120.3439.672.camel@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, 2003-12-11 at 03:31, Manu M P wrote:
> Friends
>
> The man page of createuser shows that only superusers can create users
> with "createuser". How can i make an ordinary user a super user?

ALTER USER username WITH CREATEUSER

(run by an existing superuser)

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"The spirit of the Lord GOD is upon me; because the
LORD hath anointed me to preach good tidings unto the
meek; he hath sent me to bind up the brokenhearted, to
proclaim liberty to the captives, and the opening of
the prison to them that are bound."
Isaiah 61:1

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Smitha V. Babu 2003-12-11 09:57:48 uITRON
Previous Message Alan T. Miller 2003-12-11 08:44:31 Something like 'to_days' in postgresql? Help with a MySQL migration...