Re: Clarification on View Privileges and Operator Execution in PostgreSQL

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Clarification on View Privileges and Operator Execution in PostgreSQL
Дата
Msg-id CAKFQuwYGKAeohDYe9m7ZBwto8wOc1G20dZxUJVv-aNh6St-CRg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Clarification on View Privileges and Operator Execution in PostgreSQL  (Ayush Vatsa <ayushvatsa1810@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Sun, Apr 7, 2024 at 9:32 AM Ayush Vatsa <ayushvatsa1810@gmail.com> wrote:
> Functions in the view are executed with the privileges of the user executing the query or the function owner
So does that imply to the function associated with the operators (both builtin and user defined) too.
Basically wanted to know about this -
> Now table x will be accessed (SELECT * FROM x) with "postgres" privileges but who will execute the 
> underlying function inside the ( > ) operator ? Is it postgres or alex?


An operator is a function invocation with special syntax.  So I expect that sentence to apply.

If you want to confirm what the documentation says create a custom operator/function that alex is not permitted to execute and have them query a view defined by postgres that uses that function.

David J.

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

Предыдущее
От: Ayush Vatsa
Дата:
Сообщение: Re: Clarification on View Privileges and Operator Execution in PostgreSQL
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Clarification on View Privileges and Operator Execution in PostgreSQL