Re: grant privileges across schemas

On Thu, Apr 20, 2006 at 13:52:38 -0300,
Fernan Aguero <fernan(at)iib(dot)unsam(dot)edu(dot)ar> wrote:
> +----[ Bruno Wolff III <bruno(at)wolff(dot)to> (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.