Re: [HACKERS] Schema grants for creating and dropping objects

2011-10-09 Thread Marc Munro
On Sun, 2011-10-09 at 11:58 -0400, Tom Lane wrote: > Marc Munro writes: > > It seems that in order to create an object in a given schema, I must > > have been granted create privilege on the schema. But in order to drop > > that object I require usage privilege. > > > This means that with the

Re: [HACKERS] Schema grants for creating and dropping objects

2011-10-09 Thread Tom Lane
Marc Munro writes: > It seems that in order to create an object in a given schema, I must > have been granted create privilege on the schema. But in order to drop > that object I require usage privilege. > This means that with the right privilege settings I can create objects > that I cannot s

[HACKERS] Schema grants for creating and dropping objects

2011-10-08 Thread Marc Munro
It seems that in order to create an object in a given schema, I must have been granted create privilege on the schema. But in order to drop that object I require usage privilege. This means that with the right privilege settings I can create objects that I cannot subsequently drop, or can drop