Re: create user access only to specific tables

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Thilina Ranaweera <tranaweera(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: create user access only to specific tables
Date: 2006-09-14 06:31:11
Message-ID: 20060914063111.GB72750@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Sep 12, 2006 at 06:11:19PM +0600, Thilina Ranaweera wrote:
> I am new to PostgreSql .Please tell me how to define user access only to
> selected tables

See the GRANT and REVOKE commands.

http://www.postgresql.org/docs/8.1/interactive/ddl-priv.html
http://www.postgresql.org/docs/8.1/interactive/sql-grant.html
http://www.postgresql.org/docs/8.1/interactive/sql-revoke.html

--
Michael Fuhr

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-09-14 12:48:33 Re: real and effective user ids must match
Previous Message Michael Fuhr 2006-09-14 06:26:33 Re: real and effective user ids must match