[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



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 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

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

--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite]

Powered by Linux