Re: alter table owner doesn't update acl information

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Madeleine Theile" <mt(at)theile(dot)net>
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:15:09
Message-ID: 12101.1115928909@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Madeleine Theile 2005-05-12 20:38:31 Re: alter table owner doesn't update acl information
Previous Message Mark Borins 2005-05-12 19:56:42 Re: Data Modelling Tools