possibly something happened to your select_catalog_role. sys owns the objects so he doesn't need the role to be able to see them. what error did it give that let you know that select_catalog_role wasn't working?