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 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
-----------------------------------------------------------------
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
Thomas Lockhart
Date:
> What can be wrong?

Postgres needs to be told about martin:

createuser martin
                    - Thomas

Re: problems with GRANT on Solaris 8

From
"Martin A. Marques"
Date:
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@math.unl.edu.ar
Santa Fe - Argentina        http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------