Duplicating a database user

Duplicating a database user

If you are looking to create a user in a new database that is the same as another user then run these statements for the user you want to duplicate

select dbms_metadata.get_ddl('USER','username') FROM DUAL;
select DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT','username') FROM DUAL;
select DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','username') FROM DUAL;
select DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','username') FROM DUAL;
select DBMS_METADATA.GET_granted_DDL('TABLESPACE_QUOTA', 'username') FROM dual;

Now take the resulting data and run it on the new database