Skip site navigation (1) Skip section navigation (2)

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

From: "Ben Trewern" <ben_trewern(at)hotmail(dot)com>
To: lorena_m_v(at)hotmail(dot)com, pgadmin-support(at)postgresql(dot)org
Subject: Re: Error Message: ERROR: CREATE USER: permission denied
Date: 2004-08-22 20:21:21
Message-ID: BAY8-F50eJEfY3cZP7T000351e7@hotmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
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


pgadmin-support by date

Next:From: Somchai BoongerdDate: 2004-08-23 06:25:27
Subject: Error Message: Invalid procedure call or argument
Previous:From: LorenaDate: 2004-08-20 16:02:05
Subject: Error Message: ERROR: CREATE USER: permission denied

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group