Re: Security question : Database access control
edit *pg_hba.conf *
# Allow any user on the local system to connect to any
# database under any username, but only via an IP connection:
host all 127.0.0.1 255.255.255.255 trust
# The same, over Unix-socket connections:
local all trust
what about reading pg_hba.conf comments?
local all md5
or *my nightmare *a cygwin on Win 98 everybody can can access everything
:-((((
/me shrugs
i don't use cygwin
Import Notes
Reference msg id not found: 001f01c279dc7c7e19400b0546c0@alpha.bg
On Tue, Oct 22, 2002 at 17:05:38 +0200,
Igor Georgiev <gory@alphasoft-bg.com> wrote:
Is there any way to prevent superuser to acces the database ?
I mean something like "GRANT / REVOKE CONNECT" MECHANISMI have no idea how to prevent root from access data in one of this ways :
root @ linux:~#su - postgres
postgres @ linux:/usr/local/pgsql/bin$pg_dump ....
or
edit pg_hba.conf
# Allow any user on the local system to connect to any
# database under any username, but only via an IP connection:
host all 127.0.0.1 255.255.255.255 trust
# The same, over Unix-socket connections:
local all trust
or my nightmare a cygwin on Win 98 everybody can can access everything :-((((
They can just read the raw database files as well. You have to be able to
trust whoever has root access to the system, as well as anyone who has
physical access to the system.
Import Notes
Reply to msg id not found: 001f01c279dc7c7e19400b0546c0@alpha.bgReference msg id not found: 001f01c279dc7c7e19400b0546c0@alpha.bg | Resolved by subject fallback