Thursday, October 30, 2014

Script to find who has changed the sysadmin Password

SELECT substr(d.user_name,1,30) || '~'||substr(f.user_name,1,10)||'~'||substr(d.last_update_date,1,10) key, count(*) value
FROM apps.fnd_user d, apps.fnd_user f
trunc(d.last_update_date) = trunc(sysdate)
and d.user_name = 'SYSADMIN'
and d.last_updated_by = f.user_id
GROUP BY substr(d.user_name,1,30) || '~'||substr(f.user_name,1,10)||'~'||substr(d.last_update_date,1,10);

1 comment:

  1. Thanks and Regards. Oracle Apps R12 & Fusion Training Videos at affordable cost. please check for details.