Обсуждение: createuser problem

Friends

The man page of createuser shows that only superusers can create users with "createuser". How can i make an ordinary
usera super user?  

Manu

Hi

To create a database superuser, use CREATE USER name CREATEUSER
for further details please read Documentation Chapter 4, section 4.2
http://www.postgres.org/docs/7.3/static/user-attributes.html

Chris

>-----Ursprüngliche Nachricht-----
>Von: Manu M P [mailto:manu.mp@maildrop.m2comsys.com]
>Gesendet: Donnerstag, 11. Dezember 2003 04:32
>An: pgsql-novice@postgresql.org
>Betreff: [NOVICE] createuser problem
>
>
>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?
>
>Manu
>
>
>---------------------------(end of
>broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to
>majordomo@postgresql.org
>

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.Elphick@lfix.co.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