Re: linking postgre to AD

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: Jason Tesser <JTesser(at)nbbc(dot)edu>
Cc: "Pgsql (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: linking postgre to AD
Date: 2003-11-21 20:26:26
Message-ID: 3FBE74F2.4040302@mascari.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jason Tesser wrote:

> ok so what would prevent users from using SQL tools to connect to the database
> and browse data?

#5:

"REVOKE SELECT on salaries from the public and GRANT select on
v_salaries to the public."

Since CURRENT_USER is set at connection time, and since they will only
be able to SELECT from the views, they can only see what they're
supposed to see...

Mike Mascari
mascarm(at)mascari(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-11-21 20:27:11 Re: linking postgre to AD
Previous Message Jason Tesser 2003-11-21 20:01:08 Re: linking postgre to AD