the first procedure GrantOnSchemaToRole will create a role and grnat it user defined permission
on the database schemas.
example:
exec GrantOnSchemaToRole @RoleName='db_Execute', @Permission='execute', @DatabaseName='TestDB'
this will create a role named db_Execute in the database TestDB and grant this role execute permission on all of the DB Schemas.
the sconed procedure GrantOnSchemaToRoleAllServerDBs will run GrantOnSchemaToRole for every database on the server.
