Tim Uckun wrote:
>>> drop role tim;
>>> ERROR: role "tim" cannot be dropped because some objects depend on it
>>> DETAIL: owner of default privileges on new relations belonging to
>>> role tim in schema strongmail
>>
>> DROP OWNED BY ought to get rid of that.
>
>
> Just to be clear.
>
> I don't want to drop the schema. Will DROP OWNED BY only drop the
> priviliege or the schema?
It will not drop the schema unless the schema is owned by
the role you are dropping.
Yours,
Laurenz Albe