Re: Error Message: ERROR: CREATE USER: permission denied

I don't think this is a pgAdmin problem. You need to log in as a superuser
account to create a user. The superuser is usually called postgres in a
standard PostgreSQL install although any user can be made a superuser (See
ALTER USER <username> CREATEUSER).

Try

CREATE USER <username>;

via psql or the sql window in pgAdmin to see if that does it.

Ben

>From: "Lorena" <lorena_m_v(at)hotmail(dot)com>
>To: <pgadmin-support(at)postgresql(dot)org>
>Subject: [pgadmin-support] Error Message: ERROR: CREATE USER: permission
>denied
>Date: Fri, 20 Aug 2004 11:02:05 -0500
>
>
>-- System Information --
>
>Platform: Windows 2000
>Version: 5.0
>Build: 2195 Service Pack 4
>
>-- Application Information --
>
>Name: pgAdmin II
>Version: 1.6.0
>Descripton:
>
>Name: pgSchema
>Version: 1.6.0
>Descripton: PostgreSQL Schema Objects v1.6.0
>
>-- Database Information --
>
>Version: 7.2.1
>Descripton: PostgreSQL 7.2.1 on i686-pc-winnt-msdev, compiled by msdev 6.0
>
>-- Driver Information --
>
>Name: PostgreSQL
>Version: 7.3.100
>Descripton: PostgreSQL 7.2.1 on i686-pc-winnt-msdev, compiled by msdev 6.0
>
>-- Error Information --
>
>Description: ERROR: CREATE USER: permission denied
>Number: -2147467259
>Routine: pgAdmin II:frmUser.cmdOK_Click
>
>************************************************************
>
>Insert your comment
>please send me an answer of this error because im youst starting to use
>this sw and i really need to create and work with databases, my email is
>lorena_m_v(at)hotmail(dot)com or you can contact me at lorena_medellin(at)yahoo(dot)es,
>i will be greatfull if you can help me.

_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger