Hi all,

I need to replicate all the stored procedures in a database. I've generated a DDL to re-create them, but for some reason the DDL does not contain the GRANT statements required to allow my various user groups access to the procedures.

The GRANT statements are generated when I run the DDL for each procedure one by one, but there are about 150 procedures to deal with and this is going to take me hours that I don't have to spare.

Anyone have a solution / encountered this problem before?

Many thanks,