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

2023-07-17 Thread David G. Johnston
On Mon, Jul 17, 2023, 08:44 Tomas Vondra wrote: > > > On 7/17/23 16:11, Yi Sun wrote: > > 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 u

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

2023-07-17 Thread Tomas Vondra
On 7/17/23 16:11, Yi Sun wrote: > 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 >

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

2023-07-17 Thread Yi Sun
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