Re: Installing PostgreSQL as "postgress" versus "root" Debate! - Mailing list pgsql-admin

From Doug Quale
Subject Re: Installing PostgreSQL as "postgress" versus "root" Debate!
Date
Msg-id 87k6qh2rq5.fsf@charter.net
Whole thread Raw
In response to Re: Installing PostgreSQL as "postgress" versus "root" Debate!  ("Goulet, Dick" <DGoulet@vicr.com>)
Responses Re: Installing PostgreSQL as "postgress" versus "root" Debate!  (Matt Clark <matt@ymogen.net>)
List pgsql-admin
"Goulet, Dick" <DGoulet@vicr.com> writes:

> to Postgres install as well.  I as the DBA should be able to install,
> upgrade, etc the software without access to the root account.  Simply
> put the fewer people who know the root password the fewer who can
> destroy the system and the fewer who have to be told when the password
> changes.  And the fewer people who know anything, the more secure it is.

This analysis is incomplete.  Under this scheme, if someone cracks
your account they can install trojaned or malicious executables owned
by you without cracking root.  The flaw is in believing that this
scheme requires an intruder to crack two accounts to defeat your
security.  In fact, you have doubled the number of targets but left
the amount of work required of the bad guys to compromise your system
the same (crack one account).

Put all your eggs in one basket, and WATCH THAT BASKET.

pgsql-admin by date:

Previous
From: "Tomeh, Husam"
Date:
Subject: Re: Installing PostgreSQL as "postgress" versus "root"
Next
From: David Bear
Date:
Subject: syntax issue with insert statement