| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | Magnus Hagander <magnus(at)hagander(dot)net> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Add default role 'pg_access_server_files' |
| Date: | 2018-03-06 15:00:54 |
| Message-ID: | 20180306150054.GN2416@tamriel.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Magnus, all,
* Magnus Hagander (magnus(at)hagander(dot)net) wrote:
> On Tue, Jan 2, 2018 at 1:08 PM, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
> > Suggestions on a name for this..? pg_server_copy_program?
>
> Presumably it would also be used in postgres_fdw, so that seems like a bad
> name. Maybe pg_exec_server_command?
I went with 'pg_execute_server_program', since 'program' is what we use
in the COPY syntax, et al.
Attached is an updated patch which splits up the permissions as
suggested up-thread by Magnus:
The default roles added are:
* pg_read_server_files
* pg_write_server_files
* pg_execute_server_program
Reviews certainly welcome.
Thanks!
Stephen
| Attachment | Content-Type | Size |
|---|---|---|
| add_default_role_access_server_files_v2-master.patch | text/x-diff | 16.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Steele | 2018-03-06 15:02:23 | Re: WIP Patch: Pgbench Serialization and deadlock errors |
| Previous Message | Bossart, Nathan | 2018-03-06 14:56:05 | Re: BUG #14941: Vacuum crashes |