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 CAKFQuwbMkum2q05EvhVNWXC4ij-HL-Nv=3d5yDPfZsEhNTrJbQ@mail.gmail.com
обсуждение исходный текст
Ответ на [MASSMAIL] Clarification on View Privileges and Operator Execution in PostgreSQL  (Ayush Vatsa <ayushvatsa1810@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:10 AM Ayush Vatsa <ayushvatsa1810@gmail.com> wrote:

but what about the view which contains inbuilt operators or inbuilt functions with whose privileges those will be executed. Eg.

From the create view documentation:
Functions called in the view are treated the same as if they had been called directly from the query using the view. Therefore, the user of a view must have permissions to call all functions used by the view. Functions in the view are executed with the privileges of the user executing the query or the function owner, depending on whether the functions are defined as SECURITY INVOKER or SECURITY DEFINER.

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

Предыдущее
От: Ayush Vatsa
Дата:
Сообщение: [MASSMAIL] Clarification on View Privileges and Operator Execution in PostgreSQL
Следующее
От: Ayush Vatsa
Дата:
Сообщение: Re: Clarification on View Privileges and Operator Execution in PostgreSQL