Postgres Pro
Downloads
Home   >   mailing lists

Re: create user access only to specific tables - Mailing list pgsql-admin

From Michael Fuhr
Subject Re: create user access only to specific tables
Date
Msg-id 20060914063111.GB72750@winnie.fuhr.org
Whole thread Raw
In response to create user access only to specific tables  ("Thilina Ranaweera" <tranaweera@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: real and effective user ids must match
Next
From: Tom Lane
Date:
Subject: Re: real and effective user ids must match