Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id A4B991B505F1 for ; Wed, 14 Mar 2012 12:15:01 -0300 (ADT) Received: from asbnvacz-mailrelay01.megapath.net ([207.145.128.243]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S7pul-0002QG-Gh for pgsql-admin@postgresql.org; Wed, 14 Mar 2012 15:15:00 +0000 Received: from mail4.sea5.speakeasy.net (mail4.sea5.speakeasy.net [69.17.117.48]) by asbnvacz-mailrelay01.megapath.net (Postfix) with ESMTP id E50BEA71509 for ; Wed, 14 Mar 2012 11:14:45 -0400 (EDT) Received: (qmail 4311 invoked from network); 14 Mar 2012 15:14:45 -0000 Received: by simscan 1.4.0 ppid: 16771, pid: 3364, t: 1.2243s scanners: clamav: 0.88.2/m:52/d:10739 spam: 3.0.4 Received: from 205-168-220-157.dia.static.qwest.net (HELO [192.168.2.118]) (sribe@elevated-dev.com@[205.168.220.157]) (envelope-sender ) by mail4.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 14 Mar 2012 15:14:44 -0000 Subject: Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=us-ascii From: Scott Ribe In-Reply-To: Date: Wed, 14 Mar 2012 09:14:42 -0600 Cc: Robin Iddon , Khangelani Gama , pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <2CA18772-AF64-4147-8825-3E8DB98458AD@elevated-dev.com> References: <8ecc4155e8754edef35e260a60a4a8db@mail.gmail.com> <1331722455.5503.166.camel@elliot> <1331730203.5503.174.camel@elliot> To: David Ondrejik X-Mailer: Apple Mail (2.1084) X-Spam-Checker-Version: SpamAssassin 3.0.4 (2005-06-05) on mail4.sea5 X-Spam-Level: X-Spam-Status: No, score=0.0 required=8.0 tests=none autolearn=disabled version=3.0.4 X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/84 X-Sequence-Number: 39272 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 ??? --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice