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

Re: Error: user does not exist

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Lentes, Bernd" <bernd(dot)lentes(at)gsf(dot)de>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: Error: user does not exist
Date: 2004-12-24 15:47:29
Message-ID: 200412241547.iBOFlTa18276@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-cygwin
Lentes, Bernd wrote:
> Hello to everyone, 
> 
> I'm new to postgres-SQL. I have to admin a working solution with
> postgres-SQL and cygwin unter Windows 2000.
> I have cygwin dll version 1.3.17 and postgres 7.2.3-2 (output from
> cygcheck -s).
> >From the command-line i created a new user for postgres with createuser.
> I see this user in the systemtables pg_shadow and pg_user.
> If i want to give that user ALL PRIVILEGES on a certain database, i get
> an error:
> 
> GRANT ALL PRIVILEGES ON DATABASE bestellung TO SYSTEM;
> 
> Error: parser: parse error at or near "bestellung"
> 
> Then i tried to put that user in a certain group (that this user has
> more rights, i thought):
> 
> ALTER GROUP dbadmin ADD USER SYSTEM;
> 
> Error: user "system" does not exist
> 
> I created the user SYSTEM with big characters, this is necessary in this
> case.
> The group dbadmin exists and is visible in pg_group.

Have you tried:

	ALTER GROUP dbadmin ADD USER "SYSTEM";

I think double-quotes are needed to preserver the case of user/group
names.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-cygwin by date

Next:From: Tan Phat HuynhDate: 2004-12-28 12:21:05
Subject: Can't not run initdb
Previous:From: bernd.lentesDate: 2004-12-22 12:47:00
Subject:

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