Re: Inconsistent syntax in GRANT - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Inconsistent syntax in GRANT
Date
Msg-id 200601051747.k05Hlfk05823@candle.pha.pa.us
Whole thread Raw
In response to Re: Inconsistent syntax in GRANT  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Josh Berkus wrote:
> Euler,
> 
> > It should but it's not implemented yet. There is no difficulty in doing
> > it. But I want to propose the following idea: if some object depends on
> > another object and its type is 'DEPENDENCY_INTERNAL' we could
> > grant/revoke privileges automagically to it. Or maybe create another
> > type of dependency to do so.
> > Comments?
> 
> I think this would be difficult to work out.  Personally, the only 
> clear-cut case I can think of is SERIAL columns; other dependancies would 
> require a lot of conditional logic.

Addded to TODO:
       * Allow SERIAL sequences to inherit permissions from the base table?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
Next
From: Josh Berkus
Date:
Subject: Re: Improving N-Distinct estimation by ANALYZE