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.
happy new year:-)
----- Original Message -----
From: Tarun Sharma
Sent: Tuesday, December 29, 2009 3:56 PM
Subject: Can we hide data from the superadmin
when a superuser is logged in to the postgres server ,he has priveledge to access all the databases.
can we hide the structure of some of the databases from the superuser?
like if he gives command to open such a database the postgres may ask for access password again.
as in Oracle Database Vault, organizations can pro-actively safeguard application data stored in the Oracle database from being accessed by privileged database users
kindly assist me if there exists any solution for this problem.
Disclaimer :- This e-mail and any attachment may contain confidential, proprietary or legally privileged information. If you are not the original intended recipient and have erroneously received this message, you are prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd (NSTL) accepts no responsibilities for loss or damage arising from the use of the information transmitted by this email including damages from virus and further acknowledges that no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of NSTL.
pgsql-hackers by date
|Next:||From: Joachim Wieland||Date: 2009-12-30 11:05:18|
|Subject: Re: Hot Standy introduced problem with query cancel behavior|
|Previous:||From: Joachim Wieland||Date: 2009-12-30 10:43:08|
|Subject: Re: Cancelling idle in transaction state|