problems with GRANT on Solaris 8
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
-----------------------------------------------------------------
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:
Show quoted text
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
-----------------------------------------------------------------
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 ...
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:
Show quoted text
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).