What about moving the data in one table and making views in each schema, to see only its data, based on USERID (which should be an extra column into the table)
Usnig appropriate instead of triggers and views with check should do the trick.
Creating new schema will mean a new view and new usedid, but no other changes.
The data dictionary views are organized in similar way

Cheers Boris