Access restrictions on rows depending on value of the a column

Поиск
Список
Период
Сортировка
От Renato Cramer
Тема Access restrictions on rows depending on value of the a column
Дата
Msg-id C1C69E45A81644499CED2306D960C1550857E9@VERTICAL
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Geoff Caplan
Дата:
Сообщение: Performance critical technical key
Следующее
От: "Raymond O'Donnell"
Дата:
Сообщение: datpath error