Re: Suggestion GRANT ALTER, TRIGGER ON ALTER - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Suggestion GRANT ALTER, TRIGGER ON ALTER
Date
Msg-id 200305210905.25011.josh@agliodbs.com
Whole thread Raw
In response to Re: Suggestion GRANT ALTER, TRIGGER ON ALTER  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: Suggestion GRANT ALTER, TRIGGER ON ALTER  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Chris,

> > No, I suppose not; what David really needs is GRANT ALTER; including
> > GRANT DROP just seemed consistent.
>
> How is GRANT ALTER less powerful than GRANT DROP?  You can just ALTER
> TABLE/DROP COLUMN all the columns in the table if you like, effectively
> dropping (or wrecking) the table.

Another good point.  Makes sense to just do GRANT ALTER then, which would 
cover DROP as well.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Corner-case bugs in ThisStartUpID accounting
Next
From: wade
Date:
Subject: CVS Servers (Anonymous)