A function privilege problem - Mailing list pgsql-bugs

From 高 云龙
Subject A function privilege problem
Date
Msg-id 21A88F6A-E654-4FDE-AB06-3FDBDC0EE231@biss.com
Whole thread Raw
Responses Re: A function privilege problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 xxx”,Is this right?

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


pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: REINDEX CONCURRENTLY causes ALTER TABLE to fail
Next
From: Manuel Rigger
Date:
Subject: DROP STATISTICS results in "ERROR: tuple concurrently updated"