select a.username,b.profile,b.RESOURCE_NAME,b.LIMIT from dba_users a, dba_profiles b where 
b.resource_name='IDLE_TIME' and a.profile=b.profile and a.username='BIOMETRIA_DW';

CREATE PUBLIC DATABASE LINK "CAD_MGBR"
   CONNECT TO "MGBR" IDENTIFIED BY VALUES ':1'
   USING '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=remotedb)(PORT=1521)))(CONNECT_DATA=(SID=cad)))';

SELECT USERNAME, PROFILE, ACCOUNT_STATUS FROM DBA_USERS where username like '%MGBR%'

USERNAME PROFILE        ACCOUNT_STATUS
MGBR	 UFBR_PROFILE	OPEN

 select a.username,b.profile,b.RESOURCE_NAME,b.LIMIT from dba_users a, dba_profiles b where 
 b.resource_name='IDLE_TIME' and a.profile=b.profile and a.username='MGBR';

USERNAME PROFILE        RESOURCE_NAME      LIMIT
MGBR	 UFBR_PROFILE	IDLE_TIME	   5