Skip site navigation (1) Skip section navigation (2)

Re: Can we hide data from the superadmin

From: "Tarun Sharma" <tarun(dot)sharma(at)newgen(dot)co(dot)in>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Can we hide data from the superadmin
Date: 2009-12-30 10:45:25
Message-ID: 016501ca893d$322a16f0$583ca8c0@newkmdomain.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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.
thanks 
happy new year:-)
  ----- Original Message ----- 
  From: Tarun Sharma 
  To: pgsql-hackers(at)postgresql(dot)org 
  Sent: Tuesday, December 29, 2009 3:56 PM
  Subject: Can we hide data from the superadmin


  hi

  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.

  thanks,
  tarun sharma
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. 


Responses

pgsql-hackers by date

Next:From: Joachim WielandDate: 2009-12-30 11:05:18
Subject: Re: Hot Standy introduced problem with query cancel behavior
Previous:From: Joachim WielandDate: 2009-12-30 10:43:08
Subject: Re: Cancelling idle in transaction state

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group