On Thu, Apr 20, 2006 at 13:52:38 -0300, Fernan Aguero <[EMAIL PROTECTED]> wrote: > +----[ Bruno Wolff III <[EMAIL PROTECTED]> (19.Apr.2006 14:39): > | > | > | Granting access to a schema allows use of that schema. It does not grant > | access to objects contained in the schema. You will need to do a grant for > | each object in addition to what you are already doing. You will probably > want > | to write a script or function to do it, as there isn't a built in command > | to do grants to multiple objects. > | > +----] > > Bruno, > > thanks for your reply, yes I've found a couple of mentions > to 'write your own script/function' by searching Google. > > I just hoped someone would have come across this before and > had a solution at hand :)
I am pretty sure some sample ones have been posted to at least one of the lists and should be in the archives. I wouldn't be surprised to hear that techdocs had a sample there, if you can't find one in the archives. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match