| From: | Tim Uckun <timuckun(at)gmail(dot)com> |
|---|---|
| To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Dropping default privileges. |
| Date: | 2013-01-30 08:35:32 |
| Message-ID: | CAGuHJrPQDp6b9s8rH_Kwx9nQh+6R-rnHkmve3e0vvTEz0DZSkQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thanks.
Worked.
On Wed, Jan 30, 2013 at 9:12 PM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2013-01-30 08:35:48 | Re: Fwd: Functions not visible in pg_stat_user_functions view |
| Previous Message | Albe Laurenz | 2013-01-30 08:12:27 | Re: Dropping default privileges. |