上句简化：The USER_OBJECTS view can provide information created by the user only
再简化：The USER_OBJECTS view can provide information only.这是主句,是完整的.
about the tables and views是修饰information的状语,created by the user 也是修饰 information的状语,所以only是修饰主句的即动词provide（only是副词）,即等于下面
The USER_OBJECTS view can only provide information
about the tables and views created by the user .