Re: Reimplementing permission checks for rules - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Reimplementing permission checks for rules
Date
Msg-id 6739.970065698@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reimplementing permission checks for rules  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Reimplementing permission checks for rules
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane writes:
>> What I'm thinking about doing is eliminating the "skipAcl" RTE field
>> and instead adding an Oid field named something like "checkAclAs".
>> The semantics of this field would be "if zero, check access permissions
>> for this table using the current effective userID; but if not zero,
>> check access permissions as if you are this userID".  Then the rule
>> rewriter would do no access permission checks of its own, but would
>> set this field appropriately in RTEs that it adds to queries.  All the
>> actual permissions checking would happen in one place in the executor.

> I like it.

OK.  BTW, what is the status of the changeover you proposed re using
OIDs instead of int4 userids as the unique identifiers for users?
In other words, should my field be type Oid or type int4?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Papp Gyozo
Date:
Subject: Re: Dynamic application data refreshing
Next
From: Tom Lane
Date:
Subject: Re: Installation layout is still hazardous for shared prefixes