| From: | Lou Picciano <loupicciano(at)comcast(dot)net> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Couple of admin Qs |
| Date: | 2010-08-20 12:46:42 |
| Message-ID: | 222302061.247711.1282308402600.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Pg Admins,
As many of you have done these things already (and yes, I have to dig further into the docs...)
- Is there a privileges incantation which will limit a user's view, within a given cluster, to only those databases to which he can connect? Ie, he'd see only the 3 or 4 databases to which he has privileges? Does the privileges model permit this level of granularity?
- Can someone point to an example of how to 'trigger' an event when a user logs on/off, or performs other non-data-touching actions, such as connecting to another database? Can't build a trigger on a function call, right? Has to be based on a data change?
Tks in advance - Lou
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2010-08-20 16:07:55 | Re: Couple of admin Qs |
| Previous Message | Jan-Peter.Seifert | 2010-08-20 09:27:18 | Re: query fine in psql/pgAdmin III but error message when within plpgsql function |