ERROR: must be owner of table - ALTER TABLE

Поиск
Список
Период
Сортировка
От Edwin UY
Тема ERROR: must be owner of table - ALTER TABLE
Дата
Msg-id CA+wokJ-OMQJNxp+cW9Nbn6i0m0X2aGQ=dHPMz47QPxotnUyeWA@mail.gmail.com
обсуждение исходный текст
Ответы Re: ERROR: must be owner of table - ALTER TABLE  (Ron Johnson <ronljohnsonjr@gmail.com>)
Re: ERROR: must be owner of table - ALTER TABLE  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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


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

Предыдущее
От: Rui DeSousa
Дата:
Сообщение: Re: PITR
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: ERROR: must be owner of table - ALTER TABLE