Encapsulation of tables with functions

Поиск
Список
Период
Сортировка
От Nikola Milutinovic
Тема Encapsulation of tables with functions
Дата
Msg-id 000701c19cf4$e28a1ce0$0a3ea8c0@ev.co.yu
обсуждение исходный текст
Список pgsql-general
Hi all.

I guess you all know what encapsulation is in object oriented programming, so can it be done on PostgreSQL level?

To be precise, let's suppose:
- I have a TABLE "test", owned by user "app_owner"
- I have a FUNCTION "test_fn", owned by user "app_owner"
- This function accesses "test"
- I have another user "app_user"

Can I grant priviledges to "app_user" to execute "test_fn", but not to access "test"?

Nix.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Andy Samuel"
Дата:
Сообщение: Re: again, LIKE operator
Следующее
От: "Ed Yu"
Дата:
Сообщение: Re: create table with multiple unique fields