Re: linking postgre to AD - Mailing list pgsql-general

From Mike Mascari
Subject Re: linking postgre to AD
Date
Msg-id 3FBE74F2.4040302@mascari.com
Whole thread Raw
In response to Re: linking postgre to AD  ("Jason Tesser" <JTesser@nbbc.edu>)
List 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@mascari.com



pgsql-general by date:

Previous
From: "Jason Tesser"
Date:
Subject: Re: linking postgre to AD
Next
From: Bruno Wolff III
Date:
Subject: Re: linking postgre to AD