Re: INSERT Permission Denied

USAGE has already been granted.

On Thu, Sep 25, 2025 at 9:58 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Sam Stearns <sam. stearns@ dat. com> writes: > I have an INSERT: > that's
> failing with permission denied on the schema: > ERROR: permission denied
> for schema treg > LINE 1: SELECT 1 FROM ONLY "treg". "cd_combined_offices"
> x WHERE
> ZjQcmQRYFpfptBannerStart
> This Message Is From an External Sender
> This message came from outside your organization.
>
> ZjQcmQRYFpfptBannerEnd
>
> Sam Stearns <sam(dot)stearns(at)dat(dot)com> writes:
> > I have an INSERT:
> > that's failing with permission denied on the schema:
> > ERROR: permission denied for schema treg
> > LINE 1: SELECT 1 FROM ONLY "treg"."cd_combined_offices" x WHERE "com...
> > ^
>
> You need to grant USAGE permission on that schema. It's roughly
> comparable to search privilege on a directory in most OSes.
>
> regards, tom lane
>
>

--

Samuel Stearns
Team Lead - Database
c: 971 762 6879 | o: 971 762 6879 | DAT.com

<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>