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