Security question : Database access control
| От | Igor Georgiev |
|---|---|
| Тема | Security question : Database access control |
| Дата | |
| Msg-id | 001f01c279dc$7c7e1940$0b0546c0@alpha.bg обсуждение исходный текст |
| Ответы |
Re: Security question : Database access control
Re: Security question : Database access control |
| Список | pgsql-admin |
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 :-((((
# 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 по дате отправления: