2009/12/30 Tarun Sharma <tarun.sha...@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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
