Re: [GENERAL] Other user access to database - Mailing list pgsql-general

From Bryan White
Subject Re: [GENERAL] Other user access to database
Date
Msg-id 004d01be22f5$96a23fa0$a3f0f6ce@bryan.arcamax.com
Whole thread Raw
List pgsql-general
>Now that I have a database functional, I need to allow other users
>to have access.  Using createuser I can give other users access to
>the postmaster, but I need to give them access to my database as well.
>
>Could someone enlighten me.


Access to tables is controled with the Grant and Revoke SQL statements.

From memory try:
    grant OPERATION on TABLENAME to USER;

where

OPERATION is one of SELECT, UPDATE, DELETE, INSERT or ALL for all
operations.

TABLENAME is a comma separated list of tables.

USER is a comma separated list of users or the keyword PUBLIC.


pgsql-general by date:

Previous
From: "Chris Williams"
Date:
Subject: Error with table that exists but postgres says it doesn't
Next
From: Bob Dusek
Date:
Subject: Re: [GENERAL] Other user access to database