Error: user does not exist

Поиск
Список
Период
Сортировка
От Lentes, Bernd
Тема Error: user does not exist
Дата
Msg-id C5BFECE331DB444CAB8B246D93E28629016DE034@sw-rz004.gsf.de
обсуждение исходный текст
Ответы Re: Error: user does not exist
Список 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



В списке pgsql-cygwin по дате отправления:

Предыдущее
От: bernd.lentes@arcor.de
Дата:
Сообщение:
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Error: user does not exist