Re: alter table owner doesn't update acl information

From: "Madeleine Theile" <mt(at)theile(dot)net>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Madeleine Theile" <madeleine(dot)theile(at)cs(dot)uni-dortmund(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: alter table owner doesn't update acl information
Date: 2005-05-12 20:38:31
Message-ID: 1115930311.12121.16.camel@wine
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2005-05-12 at 16:15 -0400, Tom Lane wrote:
> "Madeleine Theile" <mt(at)theile(dot)net> writes:
> > But what if he doesn't? Then the only possibility is to drop all the
> > views and recreate them as another user in order to fix the issue with
> > the acl rights.
>
> See ALTER OWNER. The intention is to make you give away all the owned
> objects before getting rid of the user.
>
> regards, tom lane
>

Try it, it doesn't work!
I can give you examples in case you need them.

Cheers,

Madeleine

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hervé Inisan 2005-05-12 20:43:30 Re: About Types
Previous Message Tom Lane 2005-05-12 20:15:09 Re: alter table owner doesn't update acl information