insert script_permissions into table scripts
DELETE scripts
WHERE name = 'script_permissions'
GO
INSERT scripts
VALUES('script_permissions','GO')
INSERT scripts
VALUES('script_permissions','DECLARE @number INT,')
INSERT scripts
VALUES('script_permissions',' @name VARCHAR(35),')
INSERT scripts
VALUES('script_permissions',' @database VARCHAR(30),')
INSERT scripts
VALUES('script_permissions',' @line VARCHAR(80),')
INSERT scripts
VALUES('script_permissions',' @cmd VARCHAR(255)')
INSERT scripts
VALUES('script_permissions','SET NOCOUNT ON')
INSERT scripts
VALUES('script_permissions','SELECT @database = (SELECT name FROM master..sysdatabases ')
INSERT scripts
VALUES('script_permissions',' WHERE dbid = (SELECT dbid FROM master..sysprocesses')
INSERT scripts
VALUES('script_permissions',' WHERE spid = @@SPID))')
INSERT scripts
VALUES('script_permissions','SELECT @line = "/* All object permissions for database " + @database + " */"')
INSERT scripts
VALUES('script_permissions','PRINT @line')
INSERT scripts
VALUES('script_permissions','SELECT @line = "/* " + CONVERT(VARCHAR(20) ,getdate()) + " */"')
INSERT scripts
VALUES('script_permissions','PRINT @line')
INSERT scripts
VALUES('script_permissions','SELECT @line = "USE " + @database')
INSERT scripts
VALUES('script_permissions','PRINT @line')
INSERT scripts
VALUES('script_permissions','PRINT ""')
INSERT scripts
VALUES('script_permissions','PRINT "GO"')
INSERT scripts
VALUES('script_permissions','PRINT ""')
INSERT scripts
VALUES('script_permissions','SELECT @number = (SELECT MIN(number) FROM master..spt_values')
INSERT scripts
VALUES('script_permissions',' WHERE type = "O"')
INSERT scripts
VALUES('script_permissions',' AND name NOT LIKE "%system%"')
INSERT scripts
VALUES('script_permissions',' AND name NOT LIKE "%replication%"')
INSERT scripts
VALUES('script_permissions',' AND number > 0)')
INSERT scripts
VALUES('script_permissions','WHILE (@number <= (SELECT MAX(number) FROM master..spt_values')
INSERT scripts
VALUES('script_permissions',' WHERE type = "O"))')
INSERT scripts
VALUES('script_permissions',' AND (@number IS NOT NULL)')
INSERT scripts
VALUES('script_permissions',' BEGIN')
INSERT scripts
VALUES('script_permissions',' SELECT @name = (SELECT name FROM master..spt_values')
INSERT scripts
VALUES('script_permissions',' WHERE number = @number')
INSERT scripts
VALUES('script_permissions',' AND type = "O")')
INSERT scripts
VALUES('script_permissions',' SELECT @line = " Permissions on all " + @name + "s"')
INSERT scripts
VALUES('script_permissions',' PRINT ""')
INSERT scripts
VALUES('script_permissions',' PRINT "/*********************************"')
INSERT scripts
VALUES('script_permissions',' PRINT @line')
INSERT scripts
VALUES('script_permissions',' PRINT " *********************************/"')
INSERT scripts
VALUES('script_permissions',' SELECT "GRANT " + RTRIM(s.name) + " ON " + RTRIM(o.name) + " TO " + u.name ')
INSERT scripts
VALUES('script_permissions',' FROM sysprotects p, sysusers u, sysobjects o,')
INSERT scripts
VALUES('script_permissions',' master..spt_values s, master..spt_values v')
INSERT scripts
VALUES('script_permissions',' WHERE p.action = s.number')
INSERT scripts
VALUES('script_permissions',' AND s.type = "T"')
INSERT scripts
VALUES('script_permissions',' AND p.uid = u.uid')
INSERT scripts
VALUES('script_permissions',' AND o.id = p.id')
INSERT scripts
VALUES('script_permissions',' AND v.number = sysstat & 0xf')
INSERT scripts
VALUES('script_permissions',' AND v.number = @number')
INSERT scripts
VALUES('script_permissions',' AND v.type = "O"')
INSERT scripts
VALUES('script_permissions',' ORDER BY v.number,s.name')
INSERT scripts
VALUES('script_permissions',' IF @@ROWCOUNT = 0')
INSERT scripts
VALUES('script_permissions',' BEGIN')
INSERT scripts
VALUES('script_permissions',' PRINT ""')
INSERT scripts
VALUES('script_permissions',' PRINT "-- NONE --"')
INSERT scripts
VALUES('script_permissions',' PRINT ""')
INSERT scripts
VALUES('script_permissions',' END')
INSERT scripts
VALUES('script_permissions',' SELECT @number = (SELECT MIN(number) FROM master..spt_values')
INSERT scripts
VALUES('script_permissions',' WHERE type = "O"')
INSERT scripts
VALUES('script_permissions',' AND name NOT LIKE "%system%"')
INSERT scripts
VALUES('script_permissions',' AND name NOT LIKE "%replication%"')
INSERT scripts
VALUES('script_permissions',' AND number > @number)')
INSERT scripts
VALUES('script_permissions',' END')
INSERT scripts
VALUES('script_permissions','PRINT ""')
INSERT scripts
VALUES('script_permissions','PRINT "GO"')
INSERT scripts
VALUES('script_permissions','PRINT ""')