How to grant read only functions execute permission to read only user

From: Yi Sun <yinan81(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: How to grant read only functions execute permission to read only user
Date: 2023-07-17 14:11:58
Message-ID: CABWY_HBa_NDX9==b1zmXi97-hDV01JMwtshOF08pu5QHPz=UpQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello guys,

Our read only user is okay to be granted read only permission of tables.

How to grant read only functions execute permission to read only user, is
there a simple way to do it please? If not, how to get the list of read
only functions please? Then can grant one by one based on the list, thanks

Best regards
Dennis Sun

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2023-07-17 14:30:45 Re: Installation Issue
Previous Message Ron 2023-07-17 13:03:36 Re: Query take a long time and use no index