Home > mailing lists

ERROR: must be owner of table - ALTER TABLE - Mailing list pgsql-admin

From	Edwin UY
Subject	ERROR: must be owner of table - ALTER TABLE
Date	May 18 13:17:20
Msg-id	CA+wokJ-OMQJNxp+cW9Nbn6i0m0X2aGQ=dHPMz47QPxotnUyeWA@mail.gmail.com Whole thread Raw
Responses	Re: ERROR: must be owner of table - ALTER TABLE Re: ERROR: must be owner of table - ALTER TABLE
List	pgsql-admin

Tree view

Is there no other option to grant a user ALTER TABLE privilege except doing the grant <owner> to <user>/<role> :-)

I can understand it is not really ideal to grant access for the user to do ALTER TABLE, this is mainly for the TEST environment while the developers are doing their testing.

For Qual and PROD, it will be restricted to either the owner or users with superuser privileges.

Any advice is much appreciated. Thanks in advance.

Regards,

pgsql-admin by date:

From: Rui DeSousa
Date: 17 May, 20:24:33
Subject: Re: PITR

From: Ron Johnson
Date: 18 May, 13:45:25
Subject: Re: ERROR: must be owner of table - ALTER TABLE

ERROR: must be owner of table - ALTER TABLE - Mailing list pgsql-admin

Previous

Next