Re: How can I create a database at a different path and not accessible by others

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Rekha Ravi Pai <rekha(at)softjin(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How can I create a database at a different path and not accessible by others
Date: 2010-03-15 06:59:30
Message-ID: 4B9DDAD2.7090305@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rekha Ravi Pai wrote:
> Hi,
> I want to store confidential data. I created a user with createdb
> permission.
> How can I prevent others accessing tables created by this user?

if you don't grant privileges to other roles or users, then only the
table creator can access the created table.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2010-03-15 07:41:36 Re: Yikes: ERROR: out of memory
Previous Message Rekha Ravi Pai 2010-03-15 06:34:16 How can I create a database at a different path and not accessible by others