| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Nicolas Kowalski <Nicolas(dot)Kowalski(at)imag(dot)fr> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Trigger with current user |
| Date: | 2001-07-05 14:03:51 |
| Message-ID: | 2819.994341831@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Nicolas Kowalski <Nicolas(dot)Kowalski(at)imag(dot)fr> writes:
> - if the current user is declared as one of the lists maintainers
> ("SELECT maintainer FROM sys_mailing_lists;"), he(she) will be able to
> SELECT, INSERT, UPDATE & DELETE rows in the 'sys_mailing_members' table,
> - if not he(she) will only be able to do SELECT's on
> 'sys_mailing_members'.
Why do you need to build this from spare parts? Use GRANT. Possibly
create a GROUP to list the maintainers (makes life easier if the same
set of users should have similar permissions on multiple tables).
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-07-05 14:13:32 | Re: trigger inheritance |
| Previous Message | omid omoomi | 2001-07-05 13:48:00 | RE: Table Description!! |