| From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
|---|---|
| To: | Aidan Van Dyk <aidan(at)highrise(dot)ca> |
| Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Hannu Krosing <hannu(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: What Would You Like To Do? |
| Date: | 2011-09-14 17:01:57 |
| Message-ID: | CAJKUy5ieBjjUg6jLuhKNt6hAzMKwPnnTK5Pm7pfXACu+utV5+Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Sep 14, 2011 at 11:49 AM, Aidan Van Dyk <aidan(at)highrise(dot)ca> wrote:
>
> But I found it useful when needing to hand out "seperate" usernames
> for different apps because they all needed to have their own
> search_path and other settings set before login (yes, dumb apps,
> mostly odbc), and be able to have the same "userid" for different
> databases, using different settings...
>
why "before" login? in 9.0+ you can use ALTER ROLE ... IN DATABASE,
doesn't it help?
pre 9.0 need the db_user_namespace GUC for that, though
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gunnlaugur Þór Briem | 2011-09-14 17:53:22 | Constraint exclusion on UNION ALL subqueries with WHERE conditions |
| Previous Message | Aidan Van Dyk | 2011-09-14 16:49:01 | Re: What Would You Like To Do? |