Re: ERROR: must be owner of table - ALTER TABLE

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: ERROR: must be owner of table - ALTER TABLE
Дата
Msg-id CANzqJaCa_mxU_rKTWFQ9uvcRQuG83R4qmKWoCAN6cPQh5AkeAg@mail.gmail.com
обсуждение исходный текст
Ответ на ERROR: must be owner of table - ALTER TABLE  (Edwin UY <edwin.uy@gmail.com>)
Список pgsql-admin
On Sat, May 18, 2024 at 6:17 AM Edwin UY <edwin.uy@gmail.com> wrote:
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.


"The right to drop an object, or to alter its definition in any way, is not treated as a grantable privilege; it is inherent in the owner, and cannot be granted or revoked. (However, a similar effect can be obtained by granting or revoking membership in the role that owns the object; see below.) The owner implicitly has all grant options for the object, too."

В списке pgsql-admin по дате отправления:

Предыдущее
От: Edwin UY
Дата:
Сообщение: ERROR: must be owner of table - ALTER TABLE
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: ERROR: must be owner of table - ALTER TABLE