Tarun Sharma wrote: > 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.
It is only available to all if all is somebody who has superuser access to the operating system, which is something you should avoid. If you don't trust your OS superuser, there's nothing you can do. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
