Re: BUG #16795: Can't give "grant execute on pg_start_backup to .."

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #16795: Can't give "grant execute on pg_start_backup to .."
Дата
Msg-id 1849914.1609188492@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #16795: Can't give "grant execute on pg_start_backup to .."  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16795: Can't give "grant execute on pg_start_backup to .."  (Ken Karma <ken.karma@gmail.com>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> postgres=# grant EXECUTE on pg_catalog.pg_start_backup to backup ;
> ERROR:  relation "pg_catalog.pg_start_backup" does not exist

pg_start_backup is a function not a table.  Try

grant execute on function pg_start_backup to backup;

(In versions before PG10 you'd need to specify the function's
arguments too.  Newer versions allow this shortcut as long as there's
only one function by that name.)

            regards, tom lane



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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16795: Can't give "grant execute on pg_start_backup to .."
Следующее
От: Ken Karma
Дата:
Сообщение: Re: BUG #16795: Can't give "grant execute on pg_start_backup to .."