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 issomething wanted and nice. You can use "GRANT TO
LOCALfoo" rather thanconnect more commands together.
Karel
-- Karel Zak <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/