By Chris Malek | 04 January 2011
Deleting Portal User favorites
Here is a SQL that will delete user portal favorites. You may need this if a user has favorited a component that does not exist or that you no longer want them to favorite because you hide it or removed it from Structure and content.
DELETE PSPRUFDEFN where PORTAL_OBJNAME IN ('xxx', 'yyy');