Re: table inheritance and privileges

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ted Toth <txtoth(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: table inheritance and privileges
Date: 2022-09-28 19:49:56
Message-ID: 4031154.1664394596@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ted Toth <txtoth(at)gmail(dot)com> writes:
> I'm dynamically creating tables that inherit from another table but
> they don't inherit the access privileges. Is there a way to have the
> new tables inherit their parent tables access privileges?

No, but do you need that? When accessing the parent table, there's
no need for privileges on individual children --- we only check
tables(s) directly named in the query.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2022-09-28 20:03:17 Re: Limiting the operations that client-side code can perform upon its database backend's artifacts
Previous Message Peter J. Holzer 2022-09-28 19:43:15 Re: Limiting the operations that client-side code can perform upon its database backend's artifacts