DELETE scripts WHERE name = 'script_user_xps' GO INSERT scripts VALUES('script_user_xps','/* build create scripts for existing user definded remote') INSERT scripts VALUES('script_user_xps',' stored procedures. Grant execute permission to all users') INSERT scripts VALUES('script_user_xps',' with sysprotects entries for the xp */') INSERT scripts VALUES('script_user_xps',' DECLARE @procedure varchar(255), ') INSERT scripts VALUES('script_user_xps',' @objectName varchar(30), ') INSERT scripts VALUES('script_user_xps',' @file varchar(255),') INSERT scripts VALUES('script_user_xps',' @user varchar(30)') INSERT scripts VALUES('script_user_xps',' SET NOCOUNT ON') INSERT scripts VALUES('script_user_xps',' DECLARE object_cursor CURSOR') INSERT scripts VALUES('script_user_xps',' FOR') INSERT scripts VALUES('script_user_xps',' SELECT DISTINCT o.name, c.text, u.name ') INSERT scripts VALUES('script_user_xps',' FROM master..sysobjects o, master..syscomments c,') INSERT scripts VALUES('script_user_xps',' master..sysprotects p, master..sysusers u') INSERT scripts VALUES('script_user_xps',' WHERE c.id = o.id') INSERT scripts VALUES('script_user_xps',' AND p.id = o.id') INSERT scripts VALUES('script_user_xps',' AND p.uid = u.uid') INSERT scripts VALUES('script_user_xps',' AND o.type = "X"') INSERT scripts VALUES('script_user_xps',' AND o.category = 0') INSERT scripts VALUES('script_user_xps',' OPEN object_cursor') INSERT scripts VALUES('script_user_xps',' FETCH NEXT FROM object_cursor INTO @objectName, @file, @user') INSERT scripts VALUES('script_user_xps',' WHILE (@@fetch_status <> -1)') INSERT scripts VALUES('script_user_xps',' BEGIN') INSERT scripts VALUES('script_user_xps',' SELECT @procedure = "EXECUTE sp_addextendedproc " + CHAR(39) +') INSERT scripts VALUES('script_user_xps',' @objectName + CHAR(39) + ", " + CHAR(39) +') INSERT scripts VALUES('script_user_xps',' @file + CHAR(39)') INSERT scripts VALUES('script_user_xps',' PRINT @procedure') INSERT scripts VALUES('script_user_xps',' PRINT "GO"') INSERT scripts VALUES('script_user_xps',' SELECT @procedure = "GRANT EXECUTE ON master.." +') INSERT scripts VALUES('script_user_xps',' @objectName + " TO " + @user') INSERT scripts VALUES('script_user_xps',' PRINT @procedure') INSERT scripts VALUES('script_user_xps',' PRINT "GO"') INSERT scripts VALUES('script_user_xps',' PRINT ""') INSERT scripts VALUES('script_user_xps',' FETCH NEXT FROM object_cursor INTO @objectname, @file, @user') INSERT scripts VALUES('script_user_xps',' END') INSERT scripts VALUES('script_user_xps',' DEALLOCATE object_cursor')