drop user dmiranda cascade;

create user dmiranda identified by ramones_01;
grant dba to dmiranda;
grant unlimited tablespace to dmiranda;
grant connect to dmiranda;

GRANT UNLIMITED TABLESPACE TO dmiranda;
GRANT DBA TO dmiranda;

ALTER USER dmiranda DEFAULT ROLE ALL;


select * from dba_objects where owner = 'DMIRANDA';

select username from dba_users where username = 'DMIRANDA';