Message-ID: <41F75B0F.6030504@archonet.com>
Date: Wed, 26 Jan 2005 08:55:43 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 1.0 (X11/20041206)
MIME-Version: 1.0
To: Din Adrian <adrian.din@easynet.ro>
Cc: pgsql-sql@postgresql.org
Subject: Re: private table
References: <opsk7aheyzawcxfg@adi>
In-Reply-To: <opsk7aheyzawcxfg@adi>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit

Din Adrian wrote:
> Hello,
> I am want to use a private table in postgresql(every client to see his 
> own  data).
> Is this possible? How can I do it!

If I understand what you want, then this is traditionally done using views.

CREATE TABLE base_table (
   a integer NOT NULL,
   b text,
   u name,
   PRIMARY KEY (a)
);

CREATE VIEW my_rows AS
   SELECT a,b FROM base_table WHERE u = CURRENT_USER;

Add rules so that updating my_rows updates base_table instead. Then, 
revoke access on base_table (apart from your super-user) but grant it on 
my_rows.

As far as a user is concerned "my_rows" just contains their rows and if 
they log in as a different user they will see different data.
--
   Richard Huxton
   Archonet Ltd