Re: GRANT & DROP - Mailing list pgsql-admin

From Anthony E . Greene
Subject Re: GRANT & DROP
Date
Msg-id 20010108182033.E19618@cp5340
Whole thread Raw
In response to GRANT & DROP  ("Gavin M. Roy" <gmr@readysetnet.com>)
List pgsql-admin
On Mon, 08 Jan 2001 15:09:12 Gavin M. Roy wrote:
>I recently suffered the pains of not having good security on a database
>when a developer dropped a production transaction payment table.  Thus
>now I am paying attention to what I should have before which is database
>security.  I am looking at the grant command and see it covers alot of
>important things, but the one I am most interested is DROP TABLE and I
>don't see it, nor ALTER.  Does DELETE cover DROP as well?  Anyone have
>experience here?

On my Linux system, "man l drop" displays the man page for the DROP command,
with references to specific variants of the command.

I don't know if the latest versions are different but in 6.5.3 anyone can
drop a table, even if they don't have any permissions on the rows in that
table.

Tony
--
Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
Chat:  AOL/Yahoo: TonyG05    ICQ: 91183266
Linux. The choice of a GNU Generation. <http://www.linux.org/>

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: GRANT & DROP
Next
From: "vijayendra mohan agrawal"
Date:
Subject: Connect Failed error