pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Allan Kamau <kamauallan@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Preventing database access (including valid users in other databases)
Date: Mon, 26 Sep 2005 03:09:32 -0700 (PDT)
Message-ID: <20050926100933.95050.qmail@web53507.mail.yahoo.com> (raw)

I would like to prevent users including users who may
be valid in other databases from accessing a
particular database, I have excluded database –
username associations of their usernames with the
database in the hba.conf file, but I observed that
they can still connect to the database, query metadata
(by use of \d) but cannot perform queries. Is there a
way to fully prevent database connect and query of
metadata?

Interesting scenario, I have a user who owns database
objects (tables, sequences) in a database, now I have
decided not to allow the user by connect to the
database by excluding the user's username from the
database – username association in the hba.conf, I
restarted the server. However the user can still
connect to the database, and the user can query the
objects they own but cannot query objects they do not
own in that database. Is this the expected behaviour
and should I explicitly change ownership of the
objects.

Allan.



		
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com



view thread (2+ messages)  latest in thread

Message-ID: <20050926100933.95050.qmail@web53507.mail.yahoo.com>
Permalink:  ../20050926100933.95050.qmail@web53507.mail.yahoo.com/
Also on:    postgresql.org/message-id/20050926100933.95050.qmail@web53507.mail.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: kamauallan@yahoo.com
  Subject: Re: Preventing database access (including valid users in other databases)
  In-Reply-To: <20050926100933.95050.qmail@web53507.mail.yahoo.com>
  References: <20050926100933.95050.qmail@web53507.mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox