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

Поиск
Список
Период
Сортировка
От David Ondrejik
Тема Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL
Дата
Msg-id CAPVc05NLf_615WRcm9UT5iWWuVb0TkN3t_hkWkht-qrHzGPQyw@mail.gmail.com
обсуждение исходный текст
Ответ на 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
Список pgsql-admin

Sure, you mean like this command:

sudo su root

???

 
Luckily...that option will fail using sudo...and it will be logged that it was attempted. I see where you are going with this Scott and there is an option that will work to give you a root shell, but I don't want to advertise that. That unadvertised command...if issued...would also be logged and lists the userid of the person who used the command. So there is some trail to track back to the original user.
 
Dave 



On Wed, Mar 14, 2012 at 11:14 AM, Scott Ribe <scott_ribe@elevated-dev.com> 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 them sudousers, then change the root password. This will force those users to simply type "sudo" (w/o quotes) at the beginning of each command they want to run (i.e. sudo psql db_name "insert into....").

Sure, you mean like this command:

sudo su root

???



--
Dave Ondrejik - Senior Hydrologist
National Weather Service
Middle Atlantic River Forecast Center
328 Innovation Blvd, Suite #330
State College, PA 16870
(814) 231-2403
 
See us on the web at:
 

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

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