| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Cc: | Bruno Wolff III <bruno(at)wolff(dot)to>, Andrew Chambers <andychambers2002(at)yahoo(dot)co(dot)uk> |
| Subject: | Re: GRANT access rights on rows |
| Date: | 2006-01-05 08:53:52 |
| Message-ID: | 20060105085352.GC29203@webserv.wug-glas.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
am 05.01.2006, um 2:42:31 -0600 mailte Bruno Wolff III folgendes:
> > I believe the conventional method of doing this is to create a view
> > selecting all the rows you wish to make accessable, then to grant access
> > to the view.
>
> And note that the view can use current_user which may be useful if different
> users are supposed to see different rows.
Can you explain this with a simple example?
Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2006-01-05 09:03:38 | Re: GRANT access rights on rows |
| Previous Message | A. Kretschmer | 2006-01-05 08:48:53 | Re: can't connect to postgresql via phppgadmin and pgaccess |