User Profile

User Profile

      select username,account_status,expiry_date,profile from dba_users where username like 'MYSIP_FE';

      select RESOURCE_NAME,RESOURCE_TYPE,LIMIT from dba_profiles where PROFILE='ORANGE_APPLICATION_PROFILE'

 ------------------------------------------------------

       select username,account_status,expiry_date from dba_users where account_status in ('EXPIRED','LOCKED');