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 <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
