Oracle sql Script to check Users with default password report with html

 cat def_passwd.sql

SET HEADING ON TERMOUT OFF SERVEROUTPUT OFF FEEDBACK OFF ECHO OFF PAGESIZE 1000

SET MARKUP HTML ON ENTMAP OFF SPOOL ON -

TABLE BORDER='1'

SET TERMOUT OFF

SET ECHO OFF

SET SERVEROUTPUT OFF

set feedback off

set echo off pagesize 1000 markup html on ENTMAP OFF spool on -

TABLE BORDER='1'

set hea on

set echo off

spool def_psswd.html app

SELECT SYS_CONTEXT('USERENV','DB_NAME') DB_NAME, dp.USERNAME DB_USER_WITH_DEFAULT_PASSWORD , ACCOUNT_STATUS, LOCK_DATE, EXPIRY_DATE,PASSWORD_CHANGE_DATE

FROM DBA_USERS_WITH_DEFPWD dp

join dba_users du on du.username = dp.username ;

select SYS_CONTEXT('USERENV','DB_NAME') DB_NAME,OWNER, NAME FUNCTION_NAME,   substr(TEXT,42) PASSWORD_COMPLEXCITY from (

SELECT OWNER, NAME, TYPE, LINE, replace(TEXT, chr(10), '') as TEXT FROM DBA_SOURCE WHERE /*owner = 'SYS' AND*/ name IN

    (SELECT REPLACE(limit, chr(10)) FROM dba_profiles WHERE resource_name = 'PASSWORD_VERIFY_FUNCTION')

ORDER BY NAME, LINE ) where lower(trim(text)) like '%complexity_check%';

SELECT SYS_CONTEXT('USERENV','DB_NAME') DB_NAME, PROFILE, RESOURCE_NAME, LIMIT fROM DBA_PROFILES WHERE RESOURCE_NAME='PASSWORD_LOCK_TIME';

spool off ;

exit ;