Re: BUG #16795: Can't give "grant execute on pg_start_backup to .." - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #16795: Can't give "grant execute on pg_start_backup to .."
Date
Msg-id 1849914.1609188492@sss.pgh.pa.us
Whole thread Raw
In response to BUG #16795: Can't give "grant execute on pg_start_backup to .."  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #16795: Can't give "grant execute on pg_start_backup to .."
List 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 by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16795: Can't give "grant execute on pg_start_backup to .."
Next
From: Ken Karma
Date:
Subject: Re: BUG #16795: Can't give "grant execute on pg_start_backup to .."