Postgres Pro
Downloads
Home   >   mailing lists

Re: alter table owner doesn't update acl information - Mailing list pgsql-general

From Tom Lane
Subject Re: alter table owner doesn't update acl information
Date
Msg-id 12101.1115928909@sss.pgh.pa.us
Whole thread Raw
In response to Re: alter table owner doesn't update acl information  ("Madeleine Theile" <mt@theile.net>)
Responses Re: alter table owner doesn't update acl information
List pgsql-general
Tree view 
"Madeleine Theile" <mt@theile.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

pgsql-general by date:

Previous
From: "Mark Borins"
Date:
Subject: Re: Data Modelling Tools
Next
From: "Madeleine Theile"
Date:
Subject: Re: alter table owner doesn't update acl information