Access restrictions on rows depending on value of the a column - Mailing list pgsql-general

From Renato Cramer
Subject Access restrictions on rows depending on value of the a column
Date
Msg-id C1C69E45A81644499CED2306D960C1550857E9@VERTICAL
Whole thread Raw
Responses Re: Access restrictions on rows depending on value of the a column  (Bruno Wolff III <bruno@wolff.to>)
Re: Access restrictions on rows depending on value of the a column  (Michael Fuhr <mike@fuhr.org>)
List 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.

pgsql-general by date:

Previous
From: Geoff Caplan
Date:
Subject: Performance critical technical key
Next
From: "Raymond O'Donnell"
Date:
Subject: datpath error