Re: Multiple users, same DB

From: John McKown <joarmc(at)swbell(dot)net>
To: Jeremy Buchmann <jeremy(at)wellsgaming(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Multiple users, same DB
Date: 2000-09-13 02:21:20
Message-ID: Pine.LNX.4.21.0009122120050.6502-100000@linux2.johnmckown.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

John

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Anthony E . Greene 2000-09-13 08:03:59 Re: Multiple users, same DB
Previous Message Paulo Roberto Siqueira 2000-09-13 02:05:54 PLSQL