ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 09555940FD694ABDA20A03DB9E955ADEY select du.username, du.account_status, du.lock_date, du.expiry_date, du.created, du.profile, xxen_util.yes(nvl2(duwd.username,'Y',null)) default_password, fou.ebs_applications, du.default_tablespace, du.temporary_tablespace, dtq.tablespace_quotas, du.authentication_type, xxen_util.yes(du.editions_enabled) editions_enabled, du.user_id from dba_users du, (select /*+ no_merge*/ duwd.username from dba_users_with_defpwd duwd) duwd, ( select /*+ no_merge*/ fou.oracle_username, listagg(fav.application_short_name,', ') within group (order by fav.application_short_name) ebs_applications from fnd_oracle_userid fou, fnd_product_installations fpi, fnd_application_vl fav where fou.oracle_id=fpi.oracle_id and fpi.application_id=fav.application_id group by fou.oracle_username ) fou, ( select /*+ no_merge*/ dtq.username, listagg(dtq.tablespace_name||' '||decode(dtq.max_bytes,-1,'unlimited',dtq.max_bytes/1000000||' MB'),', ') within group (order by dtq.tablespace_name) tablespace_quotas from dba_ts_quotas dtq group by dtq.username ) dtq where 1=1 and du.username=duwd.username(+) and du.username=fou.oracle_username(+) and du.username=dtq.username(+) order by du.username US DBA Users Database user accounts with their status, lock and expiry dates, profile, tablespaces and quotas. Default Password flags accounts that still have an Oracle-supplied default password (dba_users_with_defpwd). EBS Applications lists the Oracle EBS applications installed in the schema. Enginatics 1=1 1 10 1=1 du.username=:username LOV DBA Username 8E2FF36EDEDA79D2E0530100007F1FF2 Y select du.username value, null description from dba_users du order by du.username US Username 2 20 1=1 du.account_status=:account_status LOV custom Y select distinct du.account_status value, null description from dba_users du order by du.account_status US Account Status 3 30 1=1 du.expiry_date<sysdate+:expiring_days Number US Expiring within Days Show only accounts whose password expires within this number of days or has already expired 4 40 1=1 duwd.username is not null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Default Password only 5 50 1=1 du.username in (select fou.oracle_username from fnd_oracle_userid fou) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US EBS Schemas only Show only schemas registered in Oracle EBS