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 (126.96.36.199.0)?
or make use of dbms_metadata
Get all privileges from AAA
Change the DDL commands with the user 'BBB' and execute.