Re: Dropping default privileges. - Mailing list pgsql-general

From Tim Uckun
Subject Re: Dropping default privileges.
Date
Msg-id CAGuHJrPQDp6b9s8rH_Kwx9nQh+6R-rnHkmve3e0vvTEz0DZSkQ@mail.gmail.com
Whole thread Raw
In response to Re: Dropping default privileges.  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
Thanks.

Worked.

On Wed, Jan 30, 2013 at 9:12 PM, Albe Laurenz <laurenz.albe@wien.gv.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


pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: Dropping default privileges.
Next
From: Albe Laurenz
Date:
Subject: Re: Fwd: Functions not visible in pg_stat_user_functions view