Re: Dropping default privileges.

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dropping default privileges.
Date: 2013-01-30 03:59:12
Message-ID: CAGuHJrPzVLzKd02mskcZYJp_tmQvbZVXj2+LQD88TrjM9wLRdg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message News Subsystem 2013-01-30 04:41:59
Previous Message Tom Lane 2013-01-30 03:27:00 Re: Dropping default privileges.