On Thu, Apr 20, 2006 at 13:52:38 -0300, Fernan Aguero <fernan@xxxxxxxxxxxxxxxx> wrote: > +----[ Bruno Wolff III <bruno@xxxxxxxx> (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.
