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: | Raw Message | Whole Thread | 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? |