Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I create a database at a different path and not accessible by others - Mailing list pgsql-general

From John R Pierce
Subject Re: How can I create a database at a different path and not accessible by others
Date
Msg-id 4B9DDAD2.7090305@hogranch.com
Whole thread Raw
In response to How can I create a database at a different path and not accessible by others  (Rekha Ravi Pai <rekha@softjin.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Rekha Ravi Pai
Date:
Subject: How can I create a database at a different path and not accessible by others
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Yikes: ERROR: out of memory