I have a user 'abc'. Now I have created new user xyz. Can I assign all privileges of user 'abc' to new user 'xyz' in one go? Please help me.
In connection to @Littlefoot answer.
you can copy the user privileges from one of the tables in the answer here How to find the privileges and roles granted to a user in Oracle? for the first user and copy them into a script that will grant the second user the desired privileges. its a bit of a workaround but it should work just fine