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

From Kris Deugau
Subject Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL
Date
Msg-id 4F60C64D.2090907@vianet.ca
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
List 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 by date:

Previous
From: David Ondrejik
Date:
Subject: Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL
Next
From: Robin Iddon
Date:
Subject: Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL