So does the
USER not have permission to
SELECT on the schema? If you need a
ROLE to be able interact with a new object, you normally set that in same batch you do the
CREATE statement. Why not do that?
A DDL trigger to do this feels like the wrong idea (aka an XY problem). What are you actually trying to achieve here?
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.