Re: Multiple users, same DB

On 12 Sep 2000 22:21 John McKown wrote:
>On Tue, 12 Sep 2000, Jeremy Buchmann wrote:
>
>> Does anyone know how to create a postgresql user that can read/write to
an
>> existing database? I have used createuser, but it never asks if I want
the
>> new user to have access to an existing DB. When I connect to a DB with
that
>> new user, I can't read or write from any of the tables. Any
suggestions?
>>
>
>Logon as the database's owner. Now do a GRANT for the tables that the
>person should have access to. This is in the User's Guide, not the
>Administrator's Guide.

Within psql, use

\h grant

To get help on the command. There should also be man pages on SQL commands
in section l (lowercase "L"):

man l grant
man l revoke

The man page is a lot more informative than the brief usage info given in
psql.

--
Anthony E. Greene <agreene(at)pobox(dot)com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D
Linux. The choice of a GNU Generation. <http://www.linux.org/>