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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ken(dot)karma(at)gmail(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16795: Can't give "grant execute on pg_start_backup to .."
Date: 2020-12-28 20:48:12
Message-ID: 1849914.1609188492@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ken Karma 2020-12-28 21:28:44 Re: BUG #16795: Can't give "grant execute on pg_start_backup to .."
Previous Message PG Bug reporting form 2020-12-28 19:29:46 BUG #16795: Can't give "grant execute on pg_start_backup to .."