ERROR: must be owner of table - ALTER TABLE

From: Edwin UY <edwin(dot)uy(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: ERROR: must be owner of table - ALTER TABLE
Date: 2024-05-18 10:17:20
Message-ID: CA+wokJ-OMQJNxp+cW9Nbn6i0m0X2aGQ=dHPMz47QPxotnUyeWA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

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,
Ed

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2024-05-18 10:45:25 Re: ERROR: must be owner of table - ALTER TABLE
Previous Message Rui DeSousa 2024-05-17 17:24:33 Re: PITR