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

From Bruno Wolff III
Subject Re: linking postgre to AD
Date
Msg-id 20031121153945.GA372@wolff.to
Whole thread Raw
In response to Re: linking postgre to AD  ("Jason Tesser" <JTesser@nbbc.edu>)
List pgsql-general
On Fri, Nov 21, 2003 at 07:13:46 -0600,
  Jason Tesser <JTesser@nbbc.edu> wrote:
>
> If I did that could I use a table in Postgre as a groups table so I can control
> who can go where or who can see what in a web app?  I was wondering if Postgre
> had some built in functions that could help me out here?

You can use groups to control access to objects in postgres.
For role level security you probably want to make your own group
tables and use views joining the groups table for rows matching the current
user, with the tables containing the tuples of interest to control access.

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: PGSQL on shared hosting
Next
From: Bruce Momjian
Date:
Subject: Re: Humor me: Postgresql vs. MySql (esp. licensing)