select username,default_tablespace,profile from dba_users where username in ('Q861','BX57');
create user BX57 identified by caSrt57#nuj profile USERS;

select 'grant '||granted_role||' to BX57;' from DBA_ROLE_PRIVS where grantee = upper('Q861');
select 'grant '||privilege||' to BX57;' from DBA_SYS_PRIVS where grantee in ('Q861');
select 'grant '||privilege||' on '||owner||'.'||table_name||' to BX57;' from DBA_TAB_PRIVS where grantee in ('Q861');
select 'grant '||privilege||' ('||column_name||') '||' on '||owner||'.'||table_name||' to BX57;' from DBA_COL_PRIVS where grantee in ('Q861');