Skip site navigation (1) Skip section navigation (2)

Re: Inconsistent syntax in GRANT

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Inconsistent syntax in GRANT
Date: 2006-01-04 19:41:36
Message-ID: 200601041141.36788.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-01-04 19:49:16
Subject: Re: Improving N-Distinct estimation by ANALYZE
Previous:From: Simon RiggsDate: 2006-01-04 19:10:29
Subject: Improving N-Distinct estimation by ANALYZE

pgsql-patches by date

Next:From: Bruce MomjianDate: 2006-01-05 00:39:42
Subject: Re: Stats collector performance improvement
Previous:From: Tom LaneDate: 2006-01-04 16:11:15
Subject: Re: TRUNCATE, VACUUM, ANALYZE privileges

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group