Re: Schema (namespace) privilege details

> Should the owner of a database (assume he's not a superuser) have
the
> right to drop any schema in his database, even if he doesn't own it?
> I can see arguments either way on that one.

Given that you've chosen to allow the owner of a schema or the table
to drop a table, it would be consistent to allow the owner of the
database, schema or table to drop the table.

Much as I'd tend to allow the owner of a trigger, the table it's on,
the schema, or the database to drop the trigger.


Technically if the owner of a database doesn't have permission to drop
a table, do they have permission to drop the database?  In which case,
pg_dump, drop create table statement, drop db, create db, restore data
will accomplish the same thing.  All we've done is make the process
long and drawn out.