Separating function privileges from tables

Поиск
Список
Период
Сортировка
От Barry Brown
Тема Separating function privileges from tables
Дата
Msg-id 22F5B117-D733-4A16-A537-E5AF8E7BA238@cs.sierracollege.edu
обсуждение исходный текст
Ответы Re: Separating function privileges from tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi all,

It's nice that privileges on views are separate from the privileges
on its underlying tables. For example, if view V queries tables A and
B, I only need to grant SELECT on the view to another user; tables A
and B can have that privilege revoked and the view works.

Are there plans to extend similar behavior to functions? That is, can
I simply grant EXECUTE on the function and not have to worry about
granting the appropriate privileges to the tables used by the function?

Thanks.

-B

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

Предыдущее
От: William Garrison
Дата:
Сообщение: Help tracking down error in postgres log
Следующее
От: Lew
Дата:
Сообщение: Re: Temporal Units