Re: problems with GRANT on Solaris 8

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problems with GRANT on Solaris 8
Date: 2000-09-11 16:28:05
Message-ID: Pine.BSF.4.10.10009110927280.11606-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Did you make a postgres user "martin"? Postgres users are not the
same as system users, you have to use CREATE USER to make a database
user with that name.

Stephan Szabo
sszabo(at)bigpanda(dot)com

On Mon, 11 Sep 2000, Martin A. Marques wrote:

> I'm running postgresql 7.0.2 on Solaris 8 and I get errors when I try to
> grant a user. The query and error are ike this:
>
> horde=# GRANT SELECT, INSERT, UPDATE ON active_sessions TO martin;
> ERROR: aclparse: non-existent user "martin"
> horde=#
>
> Now, user martin exists on as a system user (it's my personal user acount),
> and I'm runnig the query as postgres user (the database superuser).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2000-09-11 16:30:14 Re: can't read SQL dump from MySQL
Previous Message Stephan Szabo 2000-09-11 16:23:48 Re: count(*) from view??