Hi there !

I want to create a user2 which can do everything with all objects of user1. Is there a command or procedure which I can use ?
(I know how to grant privileges and to create synonyms, but I think there must be a more efficient way than entering more than 100 commands...)


P.S.: Please excuse stupid questions, I'm no dba