I'm looking for a SQL script that will delete a user (that no longer works here) from the 600 reports I have without having to delete from the report menu. I think I have something that's close... delete C --Catalog.Path, Catalog.Name, Users.UserName FROM Catalog C INNER JOIN PolicyUserRole P ON C.PolicyID = P.PolicyID INNER JOIN Users U ON P.UserID = U.UserID where U.username = 'pbgops\aamoros' AND C.NAME = 'Management' qeqw