Postgres Pro
Downloads
Home   >   mailing lists

Thread: problems with GRANT on Solaris 8

problems with GRANT on Solaris 8

From
"Martin A. Marques"
Date:
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
-----------------------------------------------------------------

Re: problems with GRANT on Solaris 8

From
"Rommel B. Abaya"
Date:
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
> -----------------------------------------------------------------

Re: problems with GRANT on Solaris 8

From
The Hermit Hacker
Date:
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).
>
> What can be wrong?

you need to create teh database user martin using the 'CREATE USER'
commmand ...

Re: problems with GRANT on Solaris 8

From
Stephan Szabo
Date:
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@bigpanda.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).