| From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Sean Chittenden <sean(at)chittenden(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Per database users/admins, handy for database virtual hosting... |
| Date: | 2004-03-26 09:11:11 |
| Message-ID: | 20040326091110.GA29029@zf.jcu.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Mar 25, 2004 at 08:24:59PM -0800, Sean Chittenden wrote:
> >You can't think that allowing the same name to appear
> >globally and locally is a good idea.
>
> Actually, I do think it is a good idea.
>
> >If I say "GRANT TO foo", who am
> >I granting privileges to?
>
> SET username_precedence TO LOCAL,GLOBAL; -- I like GLOBAL more than
> CLUSTER
> GRANT TO foo;
> SET username_precedence TO GLOBAL,LOCAL;
> GRANT TO foo;
Yes, it possible, but I not sure if this commands dependence is
something wanted and nice. You can use "GRANT TO LOCAL foo" rather than
connect more commands together.
Karel
--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-03-26 15:09:21 | Re: Per database users/admins, handy for database virtual hosting... |
| Previous Message | Richard Huxton | 2004-03-26 07:15:22 | Re: pg_advisor schema proof of concept |