A function privilege problem

From: 高 云龙 <gaoyunlong(at)biss(dot)com>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: A function privilege problem
Date: 2019-07-23 08:07:04
Message-ID: 21A88F6A-E654-4FDE-AB06-3FDBDC0EE231@biss.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi ,my postgresql is 11.1 and find a problem about the execute privilege

Now I have a new db user and a UDF. The function’s body is update a table

When I run grant update on table xxx to the new user, find that i can execute the function and don’t report "Execute permission for functions<https://www.postgresql.org/message-id/4C2BBAEA.6040805%40gmail.com> xxx”，Is this right？

How i find which db user have the privilege to a function? and the \dp+ or \df+ is not work.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Manuel Rigger 2019-07-23 12:01:56 DROP STATISTICS results in "ERROR: tuple concurrently updated"
Previous Message Michael Paquier 2019-07-23 04:28:38 Re: REINDEX CONCURRENTLY causes ALTER TABLE to fail