Permission's question

From: "Ryan J(dot) Cavicchioni" <ryan(dot)cavicchioni+public(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Permission's question
Date: 2005-03-13 18:28:33
Message-ID: d120av$2v21$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, I am new to Postgres so please bear with me.

How do you create a database where only the owner can read and write to
it. I created a database owned by a user but I noticed that when logined
in as another user that was not an owner of that database that they
could write to it. So my question is that when creating databases, is
there a way to deny everyone except for the owner? Is this something
that would be done in the pg_hba.conf. Is there a way to specify
permissions on an entire database?

If I overlooked something in the manual, please send me the link. Thank you.

- Ryan

Browse pgsql-general by date

  From Date Subject
Next Message Alex Adriaanse 2005-03-13 20:23:53 PostgreSQL training
Previous Message Martijn van Oosterhout 2005-03-13 14:14:01 Re: partitionning