Re: INSERT Permission Denied

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sam Stearns <sam(dot)stearns(at)dat(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, Dugan Kniesteadt <dugan(dot)kniesteadt(at)dat(dot)com>, Henry Ashu <henry(dot)ashu(at)dat(dot)com>, Avi Vallarapu <av(at)hexacluster(dot)ai>
Subject: Re: INSERT Permission Denied
Date: 2025-09-25 16:58:09
Message-ID: 3772273.1758819489@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Stearns 2025-09-25 17:06:18 Re: INSERT Permission Denied
Previous Message Sam Stearns 2025-09-25 16:49:24 INSERT Permission Denied