User2 must have permissions to not only connect, but to also create data.
Apply permissions to User2, then make a database connection as user2 in ArcCatalog. Copy and paste the data into User2's connection. The end results will be duplicated data in the schemas user1 and user2. From there you can delete the data in user1 schema.