> On Nov 11, 2023, at 17:20, pf@xxxxxxxxxxx wrote: > Actually, it's more eusbtle... I can make it work as "postgres"; but not > as a RO user (SELECT only): > An error occurred when executing the SQL command: > select * from a,b where regexp_replace(a.address,' ','','g') = regexp_replace(b.address,' ','','g') > > ERROR: permission denied for table a > 1 statement failed. > > I had no idea functions need permissions... GRANT EXTENSION..? The permission error isn't on the function, but on the table "a". The RO user doesn't have the appropriate permissions on it.
