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

From David Ondrejik
Subject Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL
Date
Msg-id CAPVc05NLf_615WRcm9UT5iWWuVb0TkN3t_hkWkht-qrHzGPQyw@mail.gmail.com
Whole thread Raw
In response to Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL  (Scott Ribe <scott_ribe@elevated-dev.com>)
List 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 by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL
Next
From: Scott Ribe
Date:
Subject: Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL