Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL

Поиск
Список
Период
Сортировка
От Kris Deugau
Тема Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL
Дата
Msg-id 4F60C64D.2090907@vianet.ca
обсуждение исходный текст
Ответ на Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL  (Scott Ribe <scott_ribe@elevated-dev.com>)
Ответы Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL  (Robin Iddon <robin@edesix.com>)
Список pgsql-admin
Scott Ribe wrote:
> On Mar 14, 2012, at 9:01 AM, David Ondrejik wrote:
>
>> In Linux you can setup and use the "sudo" option. For those whom you don't wish to have root access, simply make
themsudousers, then change the root password. This will force those users to simply type "sudo" (w/o quotes) at the
beginningof each command they want to run (i.e. sudo psql db_name "insert into...."). 
>
> Sure, you mean like this command:
>
> sudo su root

If properly (mis)configured.

On the other hand, you can provide very limited root access on a
command-by-command and user-by-user basis with more complex sudo
configurations, and while the first request will ask for a password,
further requests within the configured authorization timeout will still
be logged even if the user isn't asked for their password.

-kgd

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

Предыдущее
От: David Ondrejik
Дата:
Сообщение: Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL
Следующее
От: Robin Iddon
Дата:
Сообщение: Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL