Re: problems with GRANT on Solaris 8 - Mailing list pgsql-general

From Rommel B. Abaya
Subject Re: problems with GRANT on Solaris 8
Date
Msg-id 39BCE91A.1EAAAF73@ramcargroup.com
Whole thread Raw
In response to problems with GRANT on Solaris 8  ("Martin A. Marques" <martin@math.unl.edu.ar>)
List pgsql-general
is martin just a shell account?

please take note of the difference between a shell account and a PostgreSQL
account. you have to create that particular user on the database. use create
user to make a new postgresql user.



"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).
>
> What can be wrong?
>
> Thanks!
>
> --
> "And I'm happy, because you make me feel good, about me." - Melvin Udall
> -----------------------------------------------------------------
> Martín Marqués                  email:  martin@math.unl.edu.ar
> Santa Fe - Argentina           http://math.unl.edu.ar/~martin/
> Administrador de sistemas en math.unl.edu.ar
> -----------------------------------------------------------------


pgsql-general by date:

Previous
From: "Rommel B. Abaya"
Date:
Subject: Re: PostgreSQL + PHP can't connect
Next
From: The Hermit Hacker
Date:
Subject: Re: problems with GRANT on Solaris 8