This question already has an answer here:
- Duplicate an Oracle database user 1 answer
I need to grant all the privileges of a user (say 'AAA') to another user (say 'BBB').
Is there such an Oracle command (184.108.40.206.0)?
Get all privileges from AAA
Change the DDL commands with the user 'BBB' and execute.
or make use of dbms_metadata