| From: | Christophe Pettus <xof(at)thebuild(dot)com> |
|---|---|
| To: | pf(at)pfortin(dot)com |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Aren't regex_*() functions built-in? |
| Date: | 2023-11-12 01:21:56 |
| Message-ID: | 4D634333-1E86-4425-B4BC-71EA136A0D94@thebuild.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Nov 11, 2023, at 17:20, pf(at)pfortin(dot)com 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2023-11-12 01:26:59 | Re: Aren't regex_*() functions built-in? |
| Previous Message | pf | 2023-11-12 01:20:51 | Re: Aren't regex_*() functions built-in? |