Olá Eas.Edu,
Segue um modelo bem simples:
USE BASE
GO
CREATE TABLE #PERMISSAO(
OWNER VARCHAR (100),
OBJECT VARCHAR (100),
[GRANT] VARCHAR (100),
GRANTOR VARCHAR (100),
PROTECT VARCHAR (100),
ACTION VARCHAR (100),
[COLUMN] VARCHAR (100))
GO
INSERT INTO #PERMISSAO
EXEC BASE..sp_helprotect
GO
SELECT * FROM #PERMISSAO
GO
select 'GRANT SELECT, INSERT TO '+ convert(varchar(10), [GRANT])+ 'ON' + convert(varchar(10), OBJECT) from #PERMISSAO
