On Tue, Oct 22, 2002 at 17:05:38 +0200,
  Igor Georgiev <[EMAIL PROTECTED]> wrote:
> 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    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.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to