Re: Multiple users, same DB - Mailing list pgsql-admin

From John McKown
Subject Re: Multiple users, same DB
Date
Msg-id Pine.LNX.4.21.0009122120050.6502-100000@linux2.johnmckown.net
Whole thread Raw
In response to Multiple users, same DB  ("Jeremy Buchmann" <jeremy@wellsgaming.com>)
Responses Re: Multiple users, same DB  ("Anthony E . Greene" <agreene@pobox.com>)
List 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


pgsql-admin by date:

Previous
From: "Paulo Roberto Siqueira"
Date:
Subject: PLSQL
Next
From: "Anthony E . Greene"
Date:
Subject: Re: Multiple users, same DB