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 ""')