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 :-(((( |
- Re: [ADMIN] Security question : Database access control Igor Georgiev
- Re: [ADMIN] Security question : Database access contr... dima
- Re: [ADMIN] Security question : Database access c... Igor Georgiev
- Re: [ADMIN] Security question : Database acce... Stephan Szabo
- Re: [ADMIN] Security question : Database acce... Tom Lane
- Re: [ADMIN] [HACKERS] Security question : Dat... scott.marlowe
- Re: [ADMIN] [HACKERS] Security question : Dat... Rod Taylor
- Re: [ADMIN] [HACKERS] Security question :... Igor Georgiev
- Re: [ADMIN] [HACKERS] Security question :... Igor Georgiev
- Re: [ADMIN] [HACKERS] Security quest... Stephan Szabo
- Re: [ADMIN] Security question : Database access contr... Bruno Wolff III