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

*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(at)elevated-dev(dot)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
>
> ???
>
> --
> Scott Ribe
> scott_ribe(at)elevated-dev(dot)com
> http://www.elevated-dev.com/
> (303) 722-0567 voice
>
>
>
>
>

--
Dave Ondrejik - Senior Hydrologist
National Weather Service
Middle Atlantic River Forecast Center
328 Innovation Blvd, Suite #330
State College, PA 16870
(814) 231-2403
david(dot)ondrejik(at)noaa(dot)gov

See us on the web at:
http://www.weather.gov/marfc