problems with GRANT on Solaris 8

Lists: 503 토토 결과 페치 실패
From: "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
To: pgsql-hackers(at)postgresql(dot)org
Subject: problems with GRANT on Solaris 8
Date: 2000-09-11 11:14:24
Message-ID: 00091108150100.08862@math.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: 503 토토 결과 페치 실패

I'm running postgresql 7.0.2 on Solaris 8 and I get errors when I try togrant 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).

What can be wrong?

Thanks!

--
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-----------------------------------------------------------------
Martn Marqus email: martin(at)math(dot)unl(dot)edu(dot)ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: problems with GRANT on Solaris 8
Date: 2000-09-11 15:45:15
Message-ID: 39BCFE0B.2F06BAC5@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

> What can be wrong?

Postgres needs to be told about martin:

createuser martin

- Thomas

From: "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: problems with GRANT on Solaris 8
Date: 2000-09-11 21:42:29
Message-ID: Pine.LNX.4.10.10009111840150.12092-100000@math.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Mon, 11 Sep 2000, Thomas Lockhart wrote:

> > What can be wrong?
>
> Postgres needs to be told about martin:
>
> createuser martin

Sorry for the stupid question, but I come from Informix 7.30 which
doesn't have a user database (AFAIK, at least doesn't have a create user
query).

Thaks for the answer!!!

"And I'm happy, because you make me feel good, about me." - Melvin Udall
-----------------------------------------------------------------
Martín Marqués email: martin(at)math(dot)unl(dot)edu(dot)ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------