> how to use this script in Stored Procedure?

You can't, a SP can't issue DGML (Grant) statements.

You can, however, update the security tables directly (although with
caution) to added the access priviledges you need.

You need to read the System table section of the Language Reference
docs.


Sean