Re: table inheritance and privileges - Mailing list pgsql-general

From Tom Lane
Subject Re: table inheritance and privileges
Date
Msg-id 4031154.1664394596@sss.pgh.pa.us
Whole thread Raw
In response to table inheritance and privileges  (Ted Toth <txtoth@gmail.com>)
Responses Re: table inheritance and privileges
List pgsql-general
Ted Toth <txtoth@gmail.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



pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Limiting the operations that client-side code can perform upon its database backend's artifacts
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Limiting the operations that client-side code can perform upon its database backend's artifacts