Re: system administration functions with hardcoded superuser checks

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: system administration functions with hardcoded superuser checks
Дата
Msg-id CAFj8pRCO7KhxwXbLRL_cGry-hbZKOfXqLELLupwybeAjT7ZoGw@mail.gmail.com
обсуждение исходный текст
Ответ на system administration functions with hardcoded superuser checks  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: system administration functions with hardcoded superuser checks
Список pgsql-hackers
2012/12/18 Peter Eisentraut <peter_e@gmx.net>:
> There are some system administration functions that have hardcoded
> superuser checks, specifically:
>
> pg_reload_conf
> pg_rotate_logfile
>
> Some of these are useful in monitoring or maintenance tools, and the
> hardcoded superuser checks require that these tools run with maximum
> privileges.  Couldn't we just install these functions without default
> privileges and allow users to grant privileges as necessary?

isn't it too strong gun for some people ???

I believe so some one can decrease necessary rights and it opens doors
to system.

> pg_read_file
> pg_read_file_all
> pg_read_binary_file
> pg_read_binary_file_all
> pg_stat_file
> pg_ls_dir

is relative dangerous and I am not for opening these functions.

power user can simply to write extension, but he knows what he does/

Regards

Pavel



>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers



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

Предыдущее
От: Groshev Andrey
Дата:
Сообщение: Re: [GENERAL] trouble with pg_upgrade 9.0 -> 9.1
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: pg_basebackup from cascading standby after timeline switch