Postgres Pro
Downloads
Home   >   mailing lists

Security question : Database access control - Mailing list pgsql-admin

From Igor Georgiev
Subject Security question : Database access control
Date
Msg-id 001f01c279dc$7c7e1940$0b0546c0@alpha.bg
Whole thread Raw
Responses Re: Security question : Database access control
Re: Security question : Database access control
List pgsql-admin
Tree view
Is there any way to prevent superuser to acces the database ?
I mean something like "GRANT / REVOKE CONNECT" MECHANISM
 
I 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 :-((((
 
 

pgsql-admin by date:

Previous
From: John Burski
Date:
Subject: Re: RPMs for Red Hat 8.0
Next
From: Tom Lane
Date:
Subject: Re: Newbie question about pg_xlog