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

From: bernd(dot)lentes(at)arcor(dot)de
To: pgsql-cygwin(at)postgresql(dot)org
Subject:
Date: 2004-12-22 12:47:00
Message-ID: 33057224.1103719620936.JavaMail.ngmail@webmail-06.arcor-online.net (view raw or flat)
Thread:
Lists: pgsql-cygwin
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.

Anyone has an idea ?
I'm new to postgres and cygwin.

Thanks a lot, and nice christmas.

Bernd




Arcor-DSL: die echte Flatrate für alle Bandbreiten. Jetzt ohne Einrichtungspreis
einsteigen oder wechseln. Arcor-DSL ist in vielen Anschlussgebieten verfügbar.
http://www.arcor.de/home/redir.php/emf-dsl-1


pgsql-cygwin by date

Next:From: Bruce MomjianDate: 2004-12-24 15:47:29
Subject: Re: Error: user does not exist
Previous:From: Lentes, BerndDate: 2004-12-22 10:16:47
Subject: Error: user does not exist

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