If listing the objects does not provide enough information in the REMARKS column, try displaying the object by one of the following methods:
UPDATE Q.OBJECT_DIRECTORY SET RESTRICTED = 'N' WHERE OWNER = 'userid'
Enclose the value you supply for userid in single quotes.
Note: Run this query only if you do not need to track which of the user's objects are restricted and which are not. After you run this query, you can reset RESTRICTED to Y, but then you will not be able to tell which objects were originally restricted.