solution to make static changes in pg_hba.conf file?
in [PgSql]
|
Prev: [HACKERS] solution to make static changes in pg_hba.conf file?
Next: krb_server_keyfile setting doesn't work on Windows
From: Magnus Hagander on 30 Dec 2009 07:23 2009/12/30 Tarun Sharma <tarun.sharma(a)newgen.co.in>: > hi, > > i assigned super user privelledge to a user by specifing entries in pg_hba.conf file as > > host all newuser 127.1.1.1 md5 > > and the default postgres user is made access to only the default postgres databse and is no more the super user. > > the problem is that this conf file is available to all and can be changed again. > > can someone assist me with a solution to make this changes static. Only root, or someone who at least has full permissions on the PostgreSQL datafiles, can do this by default. If you have granted other users access to do it, you sohuld revoke those. One way can be to move the pg_hba.conf file to a different directory and lock down the permissions there. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |