| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| 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 15:39:45 |
| Message-ID: | 20031121153945.GA372@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Nov 21, 2003 at 07:13:46 -0600,
Jason Tesser <JTesser(at)nbbc(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-11-21 15:42:16 | Re: Humor me: Postgresql vs. MySql (esp. licensing) |
| Previous Message | Robert Treat | 2003-11-21 15:37:27 | Re: PGSQL on shared hosting |