Access restrictions on rows depending on value of the a column

From: Renato Cramer <renato(at)domsis(dot)com(dot)br>
To: "List Pgsql-General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Access restrictions on rows depending on value of the a column
Date: 2004-08-12 12:54:25
Message-ID: C1C69E45A81644499CED2306D960C1550857E9@VERTICAL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

There is data of several enterprises (ours clients) in a single database.
All tables have a column on primary key what identify the enterprise called
id_enterprise.
My objective is restrict users access on rows depending on value of the
column id_enterprise.
That is, an user can access data only of his enterprise.

I don't want use where clause.
There is some way of determine this in database?

Thanks in advance,

Renato Cramer.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2004-08-12 13:14:03 datpath error
Previous Message Geoff Caplan 2004-08-12 12:05:45 Performance critical technical key