Skip site navigation (1) Skip section navigation (2)

Re: Security question : Database access control

From: "Igor Georgiev" <gory(at)alphasoft-bg(dot)com>
To:
Cc: <pgsql-admin(at)postgresql(dot)org>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Security question : Database access control
Date: 2002-10-22 16:34:57
Message-ID: 012101c279e8$f6008d00$0b0546c0@alpha.bg (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
> They can just read the raw database files as well. 
wow I'm not sure
how about this

    edit pg_hba.conf 
        # Allow any user on the local system to connect to any
        # database under any username
        local        all                                          trust

su - posgres
psql test -U dba
or 
pg_dump test

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

In response to

pgsql-hackers by date

Next:From: Igor GeorgievDate: 2002-10-22 16:45:07
Subject: Re: [HACKERS] Security question : Database access control
Previous:From: Bruce MomjianDate: 2002-10-22 16:26:30
Subject: Re: pg_dump and large files - is this a problem?

pgsql-admin by date

Next:From: Igor GeorgievDate: 2002-10-22 16:45:07
Subject: Re: [HACKERS] Security question : Database access control
Previous:From: Igor GeorgievDate: 2002-10-22 16:19:32
Subject: Re: Quickie about Database locations

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group